Oracle in a Nutshell

Calls

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