Oracle DBMS_CAPTURE_ADM_IVK
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Not known
AUTHID CURRENT_USER
Dependencies
ALL_CAPTURE DBMS_STANDARD DBMS_STREAMS_SM
ALL_XSTREAM_OUTBOUND DBMS_STREAMS_ADM DBMS_SYSTEM
DBMS_APPLY_ADM 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
DBMS_LOGREP_UTIL_INVOK DBMS_STREAMS_RPC  
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 (new 12.1.0.2 parameter)
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
DBMS_CAPTURE_ADMIN
DBMS_STREAMS_ADM
Packages
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved