General Information |
Purpose |
Provides subprograms for starting, stopping, and configuring a capture process |
Source |
{ORACLE_HOME}/rdbms/admin/dbmscap.sql |
First Available |
9.2 |
Dependencies |
DBMS_CAPTURE_ADM |
DBMS_REPCAT_DECL |
DBMS_CAPTURE_ADM_INTERNAL |
DBMS_STREAMS_ADM |
DBMS_LOGREP_IMP |
DBMS_STREAMS_ADM_UTL |
DBMS_CAPTURE_SWITCH_ADM |
DBMS_STREAMS_ADM_UTL_INVOK |
DBMS_CAPTURE_SWITCH_INTERNAL |
DBMS_STREAMS_DECL |
DBMS_LOGREP_IMP |
DBMS_STREAMS_RPC |
DBMS_LOGREP_UTIL |
DBMS_STREAMS_RPC_INTERNAL |
DBMS_LOGREP_UTIL_INVOK |
DBMS_UTILITY |
DBMS_REPCAT_COMMON_UTL |
|
|
Exceptions |
Exception |
Description |
-26678 |
create_capture_proc |
-25338 |
inv_sync_capture_proc |
-25339 |
exp_sync_capture |
|
Object Privileges |
GRANT execute ON dbms_capture_adm TO <schema_name>; |
GRANT execute ON dbms_capture_adm TO uwclass; |
|
ABORT_GLOBAL_INSTANTIATION |
Reverses the effects of Global, Schema, or Table instantiation |
dbms_capture_adm.abort_global_instantiation; |
exec dbms_capture_adm.abort_global_instantiation; |
|
ABORT_SCHEMA_INSTANTIATION |
Reverses the effects of schema or table instantiation |
dbms_capture_adm.abort_schema_instantiation(schema_name IN VARCHAR2); |
exec dbms_capture_adm.abort_schema_instantiation('UWCLASS'); |
|
ABORT_SYNC_INSTANTIATION
(new 11g) |
Undoes prepare_sync_instantiation
Overload 1 |
dbms_capture_adm.abort_sync_instantiation(table_names IN VARCHAR2); |
exec dbms_capture_adm.abort_sync_instantiation('SERVERS'); |
Overload 2 |
dbms_capture_adm.abort_sync_instantiation(
table_names IN DBMS_UTILITY.UNCL_ARRAY); |
TBD |
|
ABORT_TABLE_INSTANTIATION |
Undoes prepare_table_instantiation |
dbms_capture_adm.abort_table_instantiation(table_name IN VARCHAR2); |
exec dbms_capture_adm.abort_table_instantiation('SERVERS'); |
|
ALTER_CAPTURE |
Alters a capture process |
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,
use_database_link IN BOOLEAN
DEFAULT NULL,
first_scn
IN NUMBER DEFAULT NULL,
negative_rule_set_name IN VARCHAR2 DEFAULT NULL,
remove_negative_rule_set IN BOOLEAN DEFAULT FALSE,
capture_user IN VARCHAR2 DEFAULT NULL,
checkpoint_retention_time IN NUMBER DEFAULT NULL); |
TBD |
|
ALTER_SYNC_CAPTURE
(new 11g) |
Alters sync capture process ruleset or capture_user |
dbms_capture_adm.alter_sync_capture(
capture_name IN VARCHAR2,
rule_set_name IN VARCHAR2 DEFAULT NULL,
capture_user IN VARCHAR2 DEFAULT NULL); |
TBD |
|
BUILD |
Extracts the data dictionary of the current database to the redo logs
and automatically specifies database supplemental logging for all primary key and unique key columns
Overload 1 |
dbms_capture_adm.build(first_scn OUT NUMBER); |
--
must be in archivelog mode
set serveroutput on
DECLARE
scnout NUMBER;
BEGIN
dbms_capture_adm.build(scnout);
dbms_output.put_line(scnout);
END;
/ |
Overload 2 |
dbms_capture_adm.build; |
exec dbms_capture_adm.build; |
|
CREATE_CAPTURE |
Creates a capture process |
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,
source_database IN VARCHAR2 DEFAULT NULL,
use_database_link IN BOOLEAN
DEFAULT FALSE,
first_scn
IN NUMBER DEFAULT NULL,
logfile_assignment IN VARCHAR2 DEFAULT
'IMPLICIT',
negative_rule_set_name IN VARCHAR2 DEFAULT NULL,
capture_user IN VARCHAR2 DEFAULT NULL,
checkpoint_retention_time IN NUMBER DEFAULT 60); |
TBD |
|
CREATE_SYNC_CAPTURE
(new 11g) |
Creates sync capture process. If the specified capture_name is
already being used by an existing synchronous or asynchronous capture,
then an error will be raised. |
dbms_capture_adm.create_sync_capture(
queue_name IN VARCHAR2,
capture_name IN VARCHAR2,
rule_set_name IN VARCHAR2,
capture_user IN VARCHAR2 DEFAULT NULL); |
TBD |
|
DROP_CAPTURE |
Drops a capture process |
dbms_capture_adm.drop_capture(
capture_name IN VARCHAR2,
drop_unused_rule_sets IN BOOLEAN DEFAULT FALSE); |
TBD |
|
INCLUDE_EXTRA_ATTRIBUTE |
Includes or excludes an extra attribute in logical change
records (LCRs) captured by the specified capture process |
dbms_capture_adm.include_extra_attribute(
capture_name IN VARCHAR2,
attribute_name IN VARCHAR2,
include IN BOOLEAN DEFAULT TRUE); |
TBD |
|
PREPARE_GLOBAL_INSTANTIATION |
Performs the synchronization necessary for instantiating all the tables in the database at another database and
can enable supplemental logging for key columns or all columns in these tables |
dbms_capture_adm.prepare_global_instantiation(
supplemental_logging IN VARCHAR2 DEFAULT 'KEYS'); |
SELECT
supplemental_log_data_min, supplemental_log_data_pk, supplemental_log_data_ui
FROM v$database;
exec dbms_capture_adm.prepare_global_instantiation;
SELECT supplemental_log_data_min, supplemental_log_data_pk, supplemental_log_data_ui
FROM v$database;
exec dbms_capture_adm.abort_global_instantiation;
SELECT supplemental_log_data_min,
supplemental_log_data_pk, supplemental_log_data_ui
FROM v$database; |
|
PREPARE_SCHEMA_INSTANTIATION |
Performs the synchronization necessary for instantiating all tables in the schema at another database and can
enable supplemental logging for key columns or all columns in these tables |
dbms_capture_adm.prepare_schema_instantiation(
schema_name IN VARCHAR2,
supplemental_logging IN VARCHAR2 DEFAULT 'KEYS'); |
exec dbms_capture_adm.prepare_schema_instantiation('UWCLASS'); |
|
PREPARE_SYNC_INSTANTIATION
(new 11g) |
Prepares a list of tables for instantiation at the source DB
Overload 1 |
dbms_capture_adm.prepare_sync_instantiation(table_names IN VARCHAR2) RETURN NUMBER; |
set serveroutput on
DECLARE
n NUMBER;
BEGIN
n := dbms_capture_adm.prepare_sync_instantiation('SERVERS');
dbms_output.put_line(n);
END;
/ |
Overload 2 |
dbms_capture_adm.prepare_sync_instantiation(
table_names IN DBMS_UTILITY.UNCL_ARRAY) RETURN NUMBER; |
set serveroutput on
DECLARE
n NUMBER;
tabarray DBMS_UTILITY.UNCL_ARRAY;
BEGIN
caparray(1) := 'SERVERS';
n := dbms_capture_adm.prepare_sync_instantiation(tabarray);
END;
/ |
|
PREPARE_TABLE_INSTANTIATION |
Performs the synchronization necessary for instantiating the table at another database and can enable supplemental
logging for key columns or all columns in the table |
dbms_capture_adm.prepare_table_instantiation(
table_name IN VARCHAR2,
supplemental_logging IN VARCHAR2 DEFAULT 'KEYS'); |
See Streams Demo 2 |
|
SET_PARAMETER |
Sets a capture process parameter to the specified value |
dbms_capture_adm.set_parameter(
capture_name IN VARCHAR2,
parameter IN VARCHAR2,
value IN VARCHAR2); |
exec dbms_capture_adm.set_parameter('capture_ex',
'_checkpoint_frequency', '100'); |
|
START_CAPTURE |
Starts the capture process, which mines redo logs and enqueues the mined redo information into the associated queue |
dbms_capture_adm.start_capture(capture_name IN VARCHAR2); |
exec dbms_capture_adm.start_capture('UW_CAPTURE'); |
|
STOP_CAPTURE |
Stops the capture process from mining redo logs |
dbms_capture_adm.stop_capture(
capture_name IN VARCHAR2,
force IN BOOLEAN DEFAULT FALSE); |
exec dbms_capture_adm.stop_capture('UW_CAPTURE', TRUE); |