Oracle9i Supplied PL/SQL Packages and Types Reference Release 2 (9.2) Part Number A96612-01 |
|
DBMS_OFFLINE_OG, 2 of 2
This procedure starts offline instantiation of a master group. You must call this procedure from the master definition site.
Note: This procedure is used to perform 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 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. |
DBMS_OFFLINE_OG.BEGIN_INSTANTIATION ( gname IN VARCHAR2, new_site IN VARCHAR2 fname IN VARCHAR2);
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.
Note: This procedure is used to perform 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 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. |
DBMS_OFFLINE_OG.BEGIN_LOAD ( gname IN VARCHAR2, new_site IN VARCHAR2);
This procedure completes offline instantiation of a master group. You must call this procedure from the master definition site.
Note: This procedure is used to perform 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 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. |
DBMS_OFFLINE_OG.END_INSTANTIATION ( gname IN VARCHAR2, new_site IN VARCHAR2);
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.
Note: This procedure is used to perform 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 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. |
DBMS_OFFLINE_OG.END_LOAD ( gname IN VARCHAR2, new_site IN VARCHAR2 fname IN VARCHAR2);
When you add a new master site to a master group by performing an offline instantiation of a master site, it may take some time to complete the offline instantiation process. This procedure resumes replication activity at all existing sites, except the new site, during offline instantiation of a master group. You typically execute this procedure after executing the DBMS_OFFLINE_OG.BEGIN_INSTANTIATION
procedure. You must call this procedure from the master definition site.
Note: This procedure is used to perform 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 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. |
DBMS_OFFLINE_OG.RESUME_SUBSET_OF_MASTERS ( gname IN VARCHAR2, new_site IN VARCHAR2 override IN BOOLEAN := false);
|
Copyright © 2000, 2002 Oracle Corporation. All Rights Reserved. |
|