16
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 16-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.