Oracle Distributed Systems

Name

DBMS_OFFLINE_OG.BEGIN_LOAD

Synopsis

Call the BEGIN_LOAD procedure from the new master site before you begin importing data. The effect is to disable triggers so that data cannot be modified during the import and to disable the propagation of changes to other master sites.

PROCEDURE DBMS_OFFLINE_OG.BEGIN_LOAD
   (gname IN VARCHAR2,
    new_site IN VARCHAR2);

Parameters are identical to those given for the BEGIN_INSTANTIATION procedure.

Exceptions

Exception Name	Number	Description
badargument	–23430	Group gname is NULL or ' ' .
missingrepgroup	–23373	Group gname does not exist.
wrongsite	–23433	BEGIN_LOAD or END_LOAD is executed at a site other than new_site.
wrongstate	–23431	Group gname is not in NORMAL state at the master definition site.

Restrictions

This procedure must be run from the new site prior to importing the replicated schema. The effect is to add the new site to the set of masters in a normal state—that is, all propagation is enabled among all sites.