Oracle Distributed Systems

Name

DBMS_OFFLINE_OG.END_LOAD

Synopsis

Call the END_LOAD procedure from the new master site when you are finished importing data. The effect is to enable propagation to all other sites participating in the replication.

PROCEDURE DBMS_OFFLINE_OG.END_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 after the data is imported.