Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_OFFLINE_OG.END_INSTANTIATION

Purpose

To complete offline instantiation of a replicated object group. You must call this procedure from the master definition site. For additional information, refer to

Syntax

The parameters for the END_INSTANTIATION procedure are described in Table 12 - 42, and the exceptions are listed in Table 12 - 43. The syntax for this procedure is shown below.

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

Parameter Description
gname The name of the object group that you are replicating to the new site.
new_site The fully qualified database name of the new site to which you are replicating the object group.

Table 12 - 42. Parameters for END_INSTANTIATION

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

Table 12 - 43. Exceptions for END_INSTANTIATION

Parameter	Description
`gname`	The name of the object group that you are replicating to the new site.
`new_site`	The fully qualified database name of the new site to which you are replicating the object group.

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