Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_OFFLINE_OG.END_LOAD

Purpose

To re-enable triggers after importing data to new master site as part of offline instantiation. You must call this procedure from the new master site. For additional information, refer to

Syntax

The parameters for the END_LOAD procedure are described in Table 12 - 44, and the exceptions are listed in Table 12 - 45. The syntax for this procedure is shown below.

DBMS_OFFLINE_OG.END_LOAD( gname     IN  VARCHAR2,
                          new_site  IN  VARCHAR2)

Parameter Description
gname The name of the object group whose members you have finished importing.
new_site The fully qualified database name of the new site at which you have imported the object group members.

Table 12 - 44. Parameters for END_LOAD

Exception Description
23430 badargument Null or empty string for object group or new master site name.
wrongsite This procedure must be called from the new master site.
23434 unknownsite Given site is not recognized by object group.
23431 wrongstate Status of the new master site must be QUIESCED.
missingrepgroup GNAME does not exist as a replicated object group.

Table 12 - 45. Exceptions for END_LOAD

Parameter	Description
`gname`	The name of the object group whose members you have finished importing.
`new_site`	The fully qualified database name of the new site at which you have imported the object group members.

Exception	Description
23430 badargument	Null or empty string for object group or new master site name.
wrongsite	This procedure must be called from the new master site.
23434 unknownsite	Given site is not recognized by object group.
23431 wrongstate	Status of the new master site must be QUIESCED.
missingrepgroup	GNAME does not exist as a replicated object group.