32
DBMS_OFFLINE_OG

The DBMS_OFFLINE_OG package contains public APIs for offline instantiation of master groups.

This chapter discusses the following topics:

• Summary of DBMS_OFFLINE_OG Subprograms

  Note: These procedures are used in performing an offline instantiation of a master table in a multimaster replication environment. These procedure should not be confused with the procedures in the DBMS_OFFLINE_SNAPSHOT package (used for performing an offline instantiation of a materialized view) 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 usage.

Summary of DBMS_OFFLINE_OG Subprograms

Table 32-1 DBMS_OFFLINE_OG Package Subprograms

Subprogram	Description
"BEGIN_INSTANTIATION Procedure"	Starts offline instantiation of a 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 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 master group.