Oracle | DBMS_CAPTURE_ADM

Oracle DBMS_CAPTURE_ADM_IVK Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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

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;