Oracle DBMS_CAPTURE_ADM_IVK
Version 18.3

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.0.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
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;

Related Topics
Built-in Functions
Built-in Packages
DBMS_CAPTURE_ADM
DBMS_CAPTURE_SWITCH_ADM
DBMS_STREAMS_ADM
What's New In 18c
What's New In 19c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx