December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_CAPTURE_ADM.ABORT_GLOBAL_INSTANTIATION;
Removes data dictionary information about the database instantiation. This procedure is the opposite of the PREPARE_GLOBAL_INSTANTIATION procedure.
PROCEDURE DBMS_CAPTURE_ADM.ABORT_SCHEMA_INSTANTIATION
(schema_name IN VARCHAR2);
Removes data dictionary information about the schema instantiation. This procedure is the opposite of the PREPARE_SCHEMA_INSTANTIATION procedure.
PROCEDURE DBMS_CAPTURE_ADM.ABORT_TABLE_INSTANTIATION
(table_name IN VARCHAR2);
Removes data dictionary information about the table instantiation. This procedure is the opposite of the PREPARE_TABLE_INSTANTIATION procedure.
PROCEDURE DBMS_CAPTURE_ADM.ALTER_CAPTURE
(capture_name IN VARCHAR2,
rule_set_name IN VARCHAR2 DEFAULT NULL,
remove_rule_set IN BOOLEAN DEFAULT FALSE,
start_scn IN NUMBER DEFAULT NULL);
Alters an existing capture process.
PROCEDURE DBMS_CAPTURE_ADM.CREATE_CAPTURE
(queue_name IN VARCHAR2,
capture_name IN VARCHAR2,
rule_set_name IN VARCHAR2 DEFAULT NULL,
start_scn IN NUMBER DEFAULT NULL);
Creates a capture process.
PROCEDURE DBMS_CAPTURE_ADM.DROP_CAPTURE
(capture_name IN VARCHAR2);
Drops an existing capture process.
PROCEDURE DBMS_CAPTURE_ADM.PREPARE_GLOBAL_INSTANTIATION;
Performs the synchronization necessary to instantiate all the tables in a database at another database.
PROCEDURE DBMS_CAPTURE_ADM.PREPARE_SCHEMA_INSTANTIATION
(schema_name IN VARCHAR2);
Performs the synchronization necessary to instantiate all the tables in a schema ...