DBMS_OFFLINE_OG, 2 of 2

DBMS_OFFLINE_OG Package

Summary of Subprograms

Table 24-1 DBMS_OFFLINE_OG Package Subprograms

Subprogram	Description
BEGIN_INSTANTIATION Procedure	Starts offline instantiation of a replicated master group.
BEGIN_LOAD Procedure	Disables triggers while data is imported to new master site as part of offline instantiation.
END_INSTANTIATION Procedure	Completes offline instantiation of a replicated master group.
END_LOAD Procedure	Re-enables triggers after importing data to new master site as part of offline instantiation.
RESUME_SUBSET_OF_ MASTERS Procedure	Resumes replication activity at all existing sites except the new site during offline instantiation of a replicated master group.

BEGIN_INSTANTIATION Procedure

This procedure starts offline instantiation of a replicated master group. You must call this procedure from the master definition site.

Note:
This procedure is used in performing an offline instantiation of a master table in a multimaster replication environment.
This procedure should not be confused with the procedures in the DBMS_OFFLINE_SNAPSHOT package (used for performing an offline instantiation of a snapshot) or with the procedures in the DBMS_REPCAT_INSTANTIATE package (used for instantiating a deployment template). See these respective packages for more information on their use.

Syntax

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

Parameters

Table 24-2 BEGIN_INSTANTIATION Procedure Parameters

Parameter	Description
gname	Name of the object group that you want to replicate to the new site.
new_site	The fully qualified database name of the new site to which you want to replicate the object group.
fname	This parameter is for internal use only. Do not set this parameter unless directed to do so by Oracle Worldwide Support.

Exceptions

Table 24-3 BEGIN_INSTANTIATION Procedure Exceptions

Exception	Description
badargument	`NULL` or empty string for object group or new master site name.
dbms_repcat. nonmasterdef	This procedure must be called from the master definition site.
sitealreadyexists	Specified site is already a master site for this object group.
wrongstate	Status of master definition site must be `QUIESCED`.
dbms_repcat. missingrepgroup	`gname` does not exist as a replicated master group.
dbms_repcat.missing_ flavor	If you receive this exception, contact Oracle Worldwide Support.

BEGIN_LOAD Procedure

This procedure disables triggers while data is imported to the new master site as part of offline instantiation. You must call this procedure from the new master site.

Syntax

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

Parameters

Table 24-4 BEGIN_LOAD Procedure Parameters

Parameter	Description
gname	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.

Exceptions

Table 24-5 BEGIN_LOAD Procedure Exceptions

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

END_INSTANTIATION Procedure

This procedure completes offline instantiation of a replicated master group. You must call this procedure from the master definition site.

Syntax

DBMS_OFFLINE_OG.END_INSTANTIATION (
  gname     IN  VARCHAR2,
  new_site  IN  VARCHAR2);

Parameters

Table 24-6 END_INSTANTIATION Procedure Parameters

Parameter	Description
gname	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.

Exceptions

Table 24-7 END_INSTANTIATION Procedure Exceptions

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

END_LOAD Procedure

This procedure re-enables triggers after importing data to new master site as part of offline instantiation. You must call this procedure from the new master site.

Syntax

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

Parameters

Table 24-8 END_LOAD Procedure Parameters

Parameter	Description
gname	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.
fname	This parameter is for internal use only. Do not set this parameter unless directed to do so by Oracle Worldwide Support.

Exceptions

Table 24-9 END_LOAD Procedure Exceptions

Exception	Description
badargument	`NULL` or empty string for object group or new master site name.
wrongsite	This procedure must be called from the new master site.
unknownsite	Specified site is not recognized by object group.
wrongstate	Status of the new master site must be `QUIESCED`.
dbms_repcat. missingrepgroup	`gname` does not exist as a replicated master group.
dbms_repcat.flavor_ noobject	If you receive this exception, contact Oracle Worldwide Support.
dbms_repcat.flavor_ contains	If you receive this exception, contact Oracle Worldwide Support.

RESUME_SUBSET_OF_MASTERS Procedure

This procedure resumes replication activity at all existing sites except the new site during offline instantiation of a replicated master group. You must call this procedure from the master definition site.

Syntax

DBMS_OFFLINE_OG.RESUME_SUBSET_OF_MASTERS (
   gname     IN  VARCHAR2,
   new_site  IN  VARCHAR2
   override  IN  BOOLEAN := FALSE);

Parameters

Table 24-10 RESUME_SUBSET_OF_MASTERS Procedure Parameters

Parameter Description

gname

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.

override

If this is TRUE, then any pending RepCat administration requests are ignored and normal replication activity is restored at each master as quickly as possible. The override parameter should be set to TRUE only in emergency situations.

If this is FALSE, then normal replication activity is restored at each master only when there is no pending RepCat administration request for gname at that master.

Exceptions

Table 24-11 RESUME_SUBSET_OF_MASTERS Procedure Exceptions

Exception	Description
badargument	`NULL` or empty string for object group or new master site name.
dbms_repcat. nonmasterdef	This procedure must be called from the master definition site.
unknownsite	Specified site is not recognized by object group.
wrongstate	Status of master definition site must be `QUIESCED`.
dbms_repcat. missingrepgroup	`gname` does not exist as a replicated master group.