Oracle DBMS_CAPTURE_ADM_IVK
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Purpose Not known
AUTHID CURRENT_USER
Dependencies
ALL_CAPTURE DBMS_REPCAT_COMMON_UTL DBMS_STREAMS_RPC
ALL_XSTREAM_OUTBOUND DBMS_REPCAT_DECL DBMS_STREAMS_SM
DBMS_APPLY_ADM DBMS_STREAMS_ADM DBMS_SYSTEM
DBMS_CAPTURE_ADM DBMS_STREAMS_ADM_UTL DBMS_UTILITY
DBMS_CAPTURE_ADM_INTERNAL DBMS_STREAMS_ADM_UTL_INVOK DBMS_XSTREAM_ADM
DBMS_LOGREP_UTIL DBMS_STREAMS_AUTO_INT DBMS_XSTREAM_ADM_UTL
DBMS_LOGREP_UTIL_INVOK DBMS_STREAMS_DECL DBMS_XSTREAM_GG_ADM
Documented No
First Available 12.1.0
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('PDBORCL');
 
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', 'PDBORCL');
 
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', 'PDBORCL');
 
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);
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
Undocumented 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

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