ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Internal utilities provideing programs for starting, stopping, and configuring the Streams capture process. The source of the captured changes is the redo logs, and the repository for the captured changes is a queue.
dbms_capture_adm_internal.alter_capture(
capture_name IN VARCHAR2,
canon_invoker IN VARCHAR2,
rule_set_name IN VARCHAR2,
remove_rule_set IN BOOLEAN,
start_scn IN NUMBER,
use_database_link IN BOOLEAN,
first_scn IN NUMBER,
negative_rule_set_name IN VARCHAR2,
remove_negative_rule_set IN BOOLEAN,
capture_user IN VARCHAR2,
checkpoint_retention_time IN NUMBER,
start_time IN TIMESTAMP,
oldest_scn IN NUMBER,
processed_lwm_scn IN NUMBER,
capproc_flags IN BINARY_INTEGER);
dbms_capture_adm_internal.create_capture(
queue_name IN VARCHAR2,
capture_name IN VARCHAR2,
canon_invoker IN VARCHAR2,
rule_set_name IN VARCHAR2,
start_scn IN NUMBER,
source_database IN VARCHAR2,
use_database_link IN BOOLEAN,
first_scn IN NUMBER,
logfile_assignment IN VARCHAR2,
i_customer_id IN BINARY_INTEGER,
negative_rule_set_name IN VARCHAR2,
start_date IN DATE,
end_date IN DATE,
capture_user IN VARCHAR2,
checkpoint_retention_time IN NUMBER,
sync_capture IN BOOLEAN,
enable_trigger IN BOOLEAN,
ckpt_fre IN BOOLEAN,
start_time IN TIMESTAMP,
wait_for_inflight_txns IN BOOLEAN,
capproc_flags IN BINARY_INTEGER,
enable_procedure IN BOOLEAN,
source_root_name IN VARCHAR2,
clone_capture_name IN VARCHAR2,
share_sid IN NUMBER);
dbms_capture_adm_internal.create_sync_capture(
queue_name IN VARCHAR2,
capture_name IN VARCHAR2,
canon_invoker IN VARCHAR2,
rule_set_name IN VARCHAR2,
capture_user IN VARCHAR2,
enable_trigger IN BOOLEAN);
dbms_capture_adm_internal.prepare_global_instantiation(
canon_invoker IN VARCHAR2,
supp_log_level IN BINARY_INTEGER,
wait_for_inflight_txns IN BOOLEAN,
container IN VARCHAR2);
dbms_capture_adm_internal.prepare_global_inst_one_pdb(
pdb_name IN VARCHAR2,
canon_invoker IN VARCHAR2,
supp_log_level IN BINARY_INTEGER,
wait_for_inflight_txns IN BOOLEAN);
dbms_capture_adm_internal.prepare_schema_instantiation(
schema_name IN VARCHAR2,
canon_invoker IN VARCHAR2,
supp_log_level IN BINARY_INTEGER,
synchronization IN VARCHAR2,
container IN VARCHAR2);
dbms_capture_adm_internal.prepare_schema_inst_cdb(
schema_name IN VARCHAR2,
pdb_name IN VARCHAR2,
canon_invoker IN VARCHAR2,
supp_log_level IN BINARY_INTEGER,
synchronization IN VARCHAR2);
dbms_capture_adm_internal.prepare_table_inst(
canon_owner IN VARCHAR2,
canon_table_name IN VARCHAR2,
supplemental_logging_level IN BINARY_INTEGER,
locking IN BOOLEAN,
container IN VARCHAR2);
dbms_capture_adm_internal.prepare_table_instantiation(
table_name IN VARCHAR2,
canon_invoker IN VARCHAR2,
supp_log_level IN BINARY_INTEGER,
synchronization IN VARCHAR2,
container IN VARCHAR2);
dbms_capture_adm_internal.prepare_table_inst_cdb(
table_name IN VARCHAR2,
pdb_name IN VARCHAR2,
canon_invoker IN VARCHAR2,
supp_log_level IN BINARY_INTEGER,
synchronization IN VARCHAR2);