Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_OFFLINE_OG.BEGIN_LOAD

Purpose

To disable triggers while data is imported 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 BEGIN_LOAD procedure are described in Table 12 - 40, and the exceptions are listed in Table 12 - 41. The syntax for this procedure is shown below.

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

Parameter Description
gname The name of the object group whose members you are importing.
new_site The fully qualified database name of the new site at which you will be importing the object group members.

Table 12 - 40. Parameters for BEGIN_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 - 41. Exceptions for BEGIN_LOAD

Parameter	Description
`gname`	The name of the object group whose members you are importing.
`new_site`	The fully qualified database name of the new site at which you will be importing 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.