Oracle | DBMS_CAPTURE_ADM

Oracle DBMS_CAPTURE_ADM_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

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.

AUTHID DEFINER

Dependencies

DBA_APPLY	DBMS_SQL	EXPDEPACT$
DBA_CAPTURE	DBMS_STANDARD	GLOBAL_NAME
DBA_CAPTURE_PARAMETERS	DBMS_STREAMS_ADM	GOLDENGATE$_CONTAINER_RULES
DBA_OBJECTS	DBMS_STREAMS_ADM_IVK	GV$ARCHIVED_LOG
DBA_REGISTERED_ARCHIVED_LOG	DBMS_STREAMS_ADM_UTL	LOGMNR_LOG$
DBA_USERS	DBMS_STREAMS_ADM_UTL_INVOK	OBJ$
DBMS_APPLY_ADM_INTERNAL	DBMS_STREAMS_AUTO_INT	PLITBLM
DBMS_ASSERT	DBMS_STREAMS_DECL	STREAMS$_CAPTURE_PROCESS
DBMS_CAPTURE_ADM	DBMS_STREAMS_MT	STREAMS$_CAPTURE_SERVER
DBMS_CAPTURE_ADM_IVK	DBMS_STREAMS_RPC	STREAMS$_PREPARE_DDL
DBMS_CAPTURE_PROCESS	DBMS_STREAMS_RPC_INTERNAL	STREAMS$_PREPARE_OBJECT
DBMS_FLASHBACK	DBMS_STREAMS_SM	STREAMS$_PROCESS_PARAMS
DBMS_LOCK	DBMS_SYSTEM	TAB$
DBMS_LOGMNR_D	DBMS_SYS_ERROR	TIMESTAMP_TO_SCN
DBMS_LOGMNR_INTERNAL	DBMS_UTILITY	USER$
DBMS_LOGREP_IMP	DBMS_XSTREAM_ADM	V$DATABASE
DBMS_LOGREP_LIB	DBMS_XSTREAM_ADM_INTERNAL	V$DB_PIPES
DBMS_LOGREP_UTIL	DBMS_XSTREAM_ADM_UTL	_DBA_CAPTURE
DBMS_LOGREP_UTIL_INVOK	DBMS_XSTREAM_GG_ADM	_DBA_GGXSTREAM_INBOUND
DBMS_PIPE	DBMS_XSTREAM_UTL_IVK	_DBA_GGXSTREAM_OUTBOUND

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvthcap.plb
{ORACLE_HOME}/rdbms/admin/prvtbcap.plb

Subprograms

ABORT_GLOBAL_INST	ENFORCE_CHECKPOINT_RETENTION	PREPARE_SCHEMA_INSTANTIATION
ABORT_GLOBAL_INSTANTIATION	GET_SOURCE_DATABASE	PREPARE_SCHEMA_INST_CDB
ABORT_GLOBAL_INST_ONE_PDB	GET_SOURCE_ROOT	PREPARE_SCHEMA_TABLES
ABORT_SCHEMA_INSTANTIATION	INCLUDE_EXTRA_ATTRIBUTE	PREPARE_SYNC_INSTANTIATION
ABORT_SCHEMA_INST_CDB	IS_CAPTURE_EXISTS	PREPARE_TABLE_INST
ABORT_SYNC_INSTANTIATION	IS_DOWNSTREAM_CAPTURE	PREPARE_TABLE_INSTANTIATION
ABORT_TABLE_INSTANTIATION	IS_EXISTING_DOWNSTREAM_CAP	PREPARE_TABLE_INST_CDB
ABORT_TABLE_INST_CDB	IS_GOLDENGATE_CAPTURE	REPLACE_DICTIONARY
ADD_LOGFILE	IS_SYNC_CAPTURE	SET_XOUT_PARAMS
ALTER_CAPTURE	IS_USE_DBLINK	STORE_PREPARE_INFO
BUILD	PREPARE_DDL	SUSPEND_CAPTURE
CREATE_CAPTURE	PREPARE_GLOBAL_INST	UPDATE_PREPARE_DDL
CREATE_SYNC_CAPTURE	PREPARE_GLOBAL_INSTANTIATION	VALIDATE_PREPARE_TABLE
DROP_CAPTURE	PREPARE_GLOBAL_INST_ONE_PDB	WAIT_FOR_INFLIGHT_TXN

ABORT_GLOBAL_INST

Undocumented dbms_capture_adm_internal.abort_global_inst(canon_invoker IN VARCHAR2);

TBD

ABORT_GLOBAL_INSTANTIATION

Undocumented dbms_capture_adm_internal.abort_global_instantiation( canon_invoker IN VARCHAR2, container IN VARCHAR2);

TBD

ABORT_GLOBAL_INST_ONE_PDB

Undocumented dbms_capture_adm_internal.abort_global_inst_one_pdb( pdb_name IN VARCHAR2, canon_invoker IN VARCHAR2);

TBD

ABORT_SCHEMA_INSTANTIATION

Undocumented dbms_capture_adm_internal.abort_schema_instantiation( schema_name IN VARCHAR2, canon_invoker IN VARCHAR2, container IN VARCHAR2);

TBD

ABORT_SCHEMA_INST_CDB

Undocumented dbms_capture_adm_internal.abort_schema_inst_cdb( schema_name IN VARCHAR2, pdb_name IN VARCHAR2, canon_invoker IN VARCHAR2);

TBD

ABORT_SYNC_INSTANTIATION

Undocumented dbms_capture_adm_internal.abort_sync_instantiation( table_names IN sys.dbms_utility.uncl_array, canon_invoker IN VARCHAR2

TBD

ABORT_TABLE_INSTANTIATION

Undocumented dbms_capture_adm_internal.abort_table_instantiation( table_name IN VARCHAR2, canon_invoker IN VARCHAR2, container IN VARCHAR2);

TBD

ABORT_TABLE_INST_CDB

Undocumented dbms_capture_adm_internal.abort_table_inst_cdb( table_name IN VARCHAR2, pdb_name IN VARCHAR2, canon_invoker IN VARCHAR2);

TBD

ADD_LOGFILE

Undocumented dbms_capture_adm_internal.add_logfile( capture_name IN VARCHAR2, file_name IN VARCHAR2, is_internal IN BOOLEAN);

TBD

ALTER_CAPTURE

Undocumented 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);

TBD

BUILD

Undocumented dbms_capture_adm_internal.build( first_scn OUT NUMBER, wait_for_inflight_txns IN VARCHAR2);

TBD

CREATE_CAPTURE

Undocumented 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);

TBD

CREATE_SYNC_CAPTURE

Undocumented 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);

TBD

DROP_CAPTURE

Undocumented

Overload 1 dbms_capture_adm_internal.drop_capture( capture_name IN VARCHAR2, drop_unused_rule_sets IN BOOLEAN, canon_invoker IN VARCHAR2);

TBD

Overload 2 dbms_capture_adm_internal.drop_capture( capture_name IN VARCHAR2, canon_invoker IN VARCHAR2);

TBD

ENFORCE_CHECKPOINT_RETENTION

Undocumented dbms_capture_adm_internal.enforce_checkpoint_retention( capture_name IN VARCHAR2, ckpt_per_day IN NUMBER, all_ckpt_keep IN NUMBER);

TBD

GET_SOURCE_DATABASE

Undocumented dbms_capture_adm_internal.get_source_database(canon_capture_name IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_SOURCE_ROOT

Undocumented dbms_capture_adm_internal.get_source_root(canon_capture_name IN VARCHAR2) RETURN VARCHAR2;

TBD

INCLUDE_EXTRA_ATTRIBUTE

Undocumented dbms_capture_adm_internal.include_extra_attribute( capture_name IN VARCHAR2, attribute_name IN VARCHAR2, include IN BOOLEAN);

TBD

IS_CAPTURE_EXISTS

Returns TRUE if the named capture process exists dbms_capture_adm_internal.is_capture_exists(canon_capture_name IN VARCHAR2) RETURN BOOLEAN;

TBD

IS_DOWNSTREAM_CAPTURE

Returns TRUE if the process is a downstream capture dbms_capture_adm_internal.is_downstream_capture( canon_source_database_name IN VARCHAR2, canon_source_root_name IN VARCHAR2) RETURN BOOLEAN;

TBD

IS_EXISTING_DOWNSTREAM_CAP

Returns TRUE if a downstream capture process currently exists dbms_capture_adm_internal.is_existing_downstream_cap(canon_capture_name IN VARCHAR2) RETURN BOOLEAN;

TBD

IS_GOLDENGATE_CAPTURE

Returns TRUE if the existing process is a GoldenGate capture dbms_capture_adm_internal.is_goldengate_capture(canon_capture_name IN VARCHAR2) RETURN BOOLEAN;

TBD

IS_SYNC_CAPTURE

Returns TRUE if the process is a synchronous capture dbms_capture_adm_internal.is_sync_capture( capture_name IN VARCHAR2, is_canon_name IN BOOLEAN) RETURN BOOLEAN;

TBD

IS_USE_DBLINK

Returns TRUE if the capture process uses a Database Link dbms_capture_adm_internal.is_use_dblink(canon_capture_name IN VARCHAR2) RETURN BOOLEAN;

TBD

PREPARE_DDL

Undocumented dbms_capture_adm_internal.prepare_ddl( canon_name IN VARCHAR2, supp_log_level IN BINARY_INTEGER);

TBD

PREPARE_GLOBAL_INST

Undocumented dbms_capture_adm_internal.prepare_global_inst( canon_invoker IN VARCHAR2, supp_log_level IN BINARY_INTEGER, wait_for_inflight_txns IN BOOLEAN);

TBD

PREPARE_GLOBAL_INSTANTIATION

Undocumented 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);

TBD

PREPARE_GLOBAL_INST_ONE_PDB

Undocumented 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);

TBD

PREPARE_SCHEMA_INSTANTIATION

Undocumented 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);

TBD

PREPARE_SCHEMA_INST_CDB

Undocumented 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);

TBD

PREPARE_SCHEMA_TABLES

Undocumented dbms_capture_adm_internal.prepare_schema_tables( canon_schema_name IN VARCHAR2, locking IN BOOLEAN, container IN VARCHAR2);

TBD

PREPARE_SYNC_INSTANTIATION

Undocumented dbms_capture_adm_internal.prepare_sync_instantiation( table_names IN sys.dbms_utility.uncl_array, canon_invoker IN VARCHAR2) RETURN NUMBER;

TBD

PREPARE_TABLE_INST

Undocumented 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);

TBD

PREPARE_TABLE_INSTANTIATION

Undocumented 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);

TBD

PREPARE_TABLE_INST_CDB

Undocumented 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);

TBD

REPLACE_DICTIONARY

Undocumented dbms_capture_adm_internal.prepare_table_inst_cdb(source_database IN VARCHAR2);

TBD

SET_XOUT_PARAMS

Undocumented dbms_capture_adm_internal.set_xout_params( canon_capture_name IN VARCHAR2, xout_exists IN BOOLEAN);

TBD

STORE_PREPARE_INFO

Undocumented dbms_capture_adm_internal.store_prepare_info( canon_name IN VARCHAR2, supp_log_level IN BINARY_INTEGER);

TBD

SUSPEND_CAPTURE

Undocumented dbms_capture_adm_internal.suspend_capture( capture_name IN VARCHAR2, suspend IN BOOLEAN);

TBD

UPDATE_PREPARE_DDL

Undocumented dbms_capture_adm_internal.update_prepare_ddl(canon_invoker IN VARCHAR2);

TBD

VALIDATE_PREPARE_TABLE

Undocumented dbms_capture_adm_internal.validate_prepare_table( canon_owner IN VARCHAR2, canon_table_name IN VARCHAR2);

TBD

WAIT_FOR_INFLIGHT_TXN

Undocumented dbms_capture_adm_internal.wait_for_inflight_txn( current_scn IN NUMBER, procname IN VARCHAR2, local_container IN BOOLEAN);

TBD