December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_OFFLINE_OG.BEGIN_INSTANTIATION
(gname IN VARCHAR2,
new_site IN VARCHAR2,
fname IN VARCHAR2);
Starts offline instantiation of new_site for gname replication group. The fname parameter is for internal use only.
PROCEDURE DBMS_OFFLINE_OG.BEGIN_LOAD
(gname IN VARCHAR2,
new_site IN VARCHAR2);
Disables triggers while data is being imported into the new_site master site. Must be called from the master site.
PROCEDURE DBMS_OFFLINE_OG.END_INSTANTIATION
(gname IN VARCHAR2,
new_site IN VARCHAR2);
Ends instantiation of new_site. Must be called from the master definition site.
PROCEDURE DBMS_OFFLINE_OG.END_LOAD
(gname IN VARCHAR2,
new_site IN VARCHAR2,
fname IN VARCHAR2);
Reenables triggers in new_site at the end of the offline instantiation and load. The fname parameter is for internal use only.
PROCEDURE DBMS_OFFLINE_OG.RESUME_SUBSET_OF_MASTERS
(gname IN VARCHAR2,
new_site IN VARCHAR2,
override IN BOOLEAN := FALSE);
Resumes replication at existing sites during replication activity to new_site. If override (new with Oracle8i) is FALSE, replication is restored at each master as quickly as possible; if override is TRUE, replication begins only when there are no pending replication requests for gname at each master.