Oracle | DBMS_CAPTURE_ADM

Oracle DBMS_CAPTURE_ADM_IVK 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 Supporting utilities for replication

AUTHID CURRENT_USER

Dependencies

ALL_CAPTURE	DBMS_LOGREP_UTIL_INVOK	DBMS_STREAMS_RPC
ALL_XSTREAM_OUTBOUND	DBMS_STANDARD	DBMS_STREAMS_SM
DBMS_APPLY_ADM	DBMS_STREAMS_ADM	DBMS_SYSTEM
DBMS_ASSERT	DBMS_STREAMS_ADM_UTL	DBMS_UTILITY
DBMS_CAPTURE_ADM	DBMS_STREAMS_ADM_UTL_INVOK	DBMS_XSTREAM_ADM
DBMS_CAPTURE_ADM_INTERNAL	DBMS_STREAMS_AUTO_INT	DBMS_XSTREAM_ADM_UTL
DBMS_LOGREP_UTIL	DBMS_STREAMS_DECL	DBMS_XSTREAM_GG_ADM

Documented No

First Available 12.1

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role

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

Subprograms

ABORT_GLOBAL_INST_IVK	CREATE_CAPTURE_IVK	PREPARE_TABLE_INST_IVK
ABORT_SCHEMA_INST_IVK	PREPARE_GLOBAL_INST_IVK	SET_PARAMETER
ABORT_TABLE_INST_IVK	PREPARE_SCHEMA_INST_IVK	SUPP_LOG_LEVEL_CHECK

ABORT_GLOBAL_INST_IVK

Undocumented dbms_capture_adm_ivk.abort_global_inst_ivk(container IN VARCHAR2);

exec dbms_capture_adm_ivk.abort_global_inst_ivk('PDBDEV');

ABORT_SCHEMA_INST_IVK

Undocumented dbms_capture_adm_ivk.abort_schema_inst_ivk( schema_name IN VARCHAR2, container IN VARCHAR2);

-- appears to be runnable from pdb$root but have not tested this as there is no validation in this proc.

      exec dbms_capture_adm_ivk.abort_schema_inst_ivk('SCOTT', 'PDBDEV');

ABORT_TABLE_INST_IVK

Undocumented dbms_capture_adm_ivk.abort_table_inst_ivk( table_name IN VARCHAR2, container IN VARCHAR2);

-- appears to be runnable from pdb$root but have not tested this as there is no validation in this proc.
exec dbms_capture_adm_ivk.abort_table_inst_ivk('SERVERS', 'PDBDEV');

CREATE_CAPTURE_IVK

Undocumented dbms_capture_adm_ivk.create_capture_ivk( queue_name IN VARCHAR2, capture_name IN VARCHAR2, rule_set_name IN VARCHAR2, start_scn IN NUMBER, source_database IN VARCHAR2, user_database_link IN BOOLEAN, first_scn IN NUMBER, logfile_assignment IN VARCHAR2, negative_rule_set_name IN VARCHAR2, capture_user IN VARCHAR2, checkpoint_retention_time IN NUMBER, start_time IN TIMESTAMP, enable_procedure IN BOOLEAN, source_root_name IN VARCHAR2, capture_class IN VARCHAR2, clone_capture_name IN VARCHAR2);

TBD

PREPARE_GLOBAL_INST_IVK

Undocumented dbms_capture_adm_ivk.prepare_global_inst_ivk( supplemental_logging IN VARCHAR2, container IN VARCHAR2);

TBD

PREPARE_SCHEMA_INST_IVK

Undocumented dbms_capture_adm_ivk.prepare_global_inst_ivk( schema_name IN VARCHAR2, supplemental_logging IN VARCHAR2, container IN VARCHAR2);

TBD

PREPARE_TABLE_INST_IVK

Undocumented dbms_capture_adm_ivk.prepare_global_inst_ivk( table_name IN VARCHAR2, supplemental_logging IN VARCHAR2, container IN VARCHAR2);

TBD

SET_PARAMETER

Undocumented dbms_capture_adm_ivk.set_parameter( capture_name IN VARCHAR2, parameter IN VARCHAR2, value IN VARCHAR2, source_database IN VARCHAR2);

TBD

SUPP_LOG_LEVEL_CHECK

Returns the level of Supplemental Logging dbms_capture_adm_ivk.supp_log_level_check( supplemental_logging IN VARCHAR2, check_for_keyalways IN BOOLEAN) RETURN BINARY_INTEGER;

-- having no idea what the proper string for the first parameter is ... I threw something at it which it appears does not work but does prove out the validity of the syntax.

SELECT supplemental_log_data_min, supplemental_log_data_pk

      FROM v$database;

      

      SUPPLEME SUP

      -------- ---

      NO       NO

      

      SELECT dbms_capture_adm_ivk.supp_log_level_check('SUPPLEMENTAL_LOG_DATA_PK')

      FROM dual;

      

      ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

      

      SELECT supplemental_log_data_min, supplemental_log_data_pk

      FROM v$database;

      

      SUPPLEME SUP

      -------- ---

      YES      NO

      

      SELECT dbms_capture_adm_ivk.supp_log_level_check('SUPPLEMENTAL_LOG_DATA_PK')

      FROM dual;