 |
|
DBMS_CAPTURE_ADM_INTERNAL package tips
Oracle Tips by Burleson Consulting |
DBMS_CAPTURE_ADM_INTERNAL
<< Return to the index
Related notes on DBMS_CAPTURE_ADM_INTERNAL:
Oracle 11g provides the following information about the DBMS_CAPTURE_ADM_INTERNAL package:
Description of the DBMS_CAPTURE_ADM_INTERNAL package:
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.ABORT_GLOBAL_INSTANTIATION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_INVOKER VARCHAR2 IN
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.ABORT_SCHEMA_INSTANTIATION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA_NAME VARCHAR2 IN
CANON_INVOKER VARCHAR2 IN
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.ABORT_SYNC_INSTANTIATION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TABLE_NAMES TABLE OF VARCHAR2(227) IN
CANON_INVOKER VARCHAR2 IN
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.ABORT_TABLE_INSTANTIATION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TABLE_NAME VARCHAR2 IN
CANON_INVOKER VARCHAR2 IN
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.ADD_LOGFILE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CAPTURE_NAME VARCHAR2 IN
FILE_NAME VARCHAR2 IN
IS_INTERNAL BOOLEAN IN DEFAULT
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.ALTER_CAPTURE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CAPTURE_NAME VARCHAR2 IN
CANON_INVOKER VARCHAR2 IN
RULE_SET_NAME VARCHAR2 IN DEFAULT
REMOVE_RULE_SET BOOLEAN IN DEFAULT
START_SCN NUMBER IN DEFAULT
USE_DATABASE_LINK BOOLEAN IN DEFAULT
FIRST_SCN NUMBER IN DEFAULT
NEGATIVE_RULE_SET_NAME VARCHAR2 IN DEFAULT
REMOVE_NEGATIVE_RULE_SET BOOLEAN IN DEFAULT
CAPTURE_USER VARCHAR2 IN DEFAULT
CHECKPOINT_RETENTION_TIME NUMBER IN DEFAULT
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.BUILD
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
FIRST_SCN NUMBER OUT
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.CREATE_CAPTURE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
CAPTURE_NAME VARCHAR2 IN
CANON_INVOKER VARCHAR2 IN
RULE_SET_NAME VARCHAR2 IN DEFAULT
START_SCN NUMBER IN DEFAULT
SOURCE_DATABASE VARCHAR2 IN DEFAULT
USE_DATABASE_LINK BOOLEAN IN DEFAULT
FIRST_SCN NUMBER IN DEFAULT
LOGFILE_ASSIGNMENT VARCHAR2 IN DEFAULT
I_CUSTOMER_ID BINARY_INTEGER IN DEFAULT
NEGATIVE_RULE_SET_NAME VARCHAR2 IN DEFAULT
START_DATE DATE IN DEFAULT
END_DATE DATE IN DEFAULT
CAPTURE_USER VARCHAR2 IN DEFAULT
CHECKPOINT_RETENTION_TIME NUMBER IN DEFAULT
SYNC_CAPTURE BOOLEAN IN DEFAULT
ENABLE_TRIGGER BOOLEAN IN DEFAULT
CKPT_FRE BOOLEAN IN DEFAULT
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.CREATE_SYNC_CAPTURE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
CAPTURE_NAME VARCHAR2 IN
CANON_INVOKER VARCHAR2 IN
RULE_SET_NAME VARCHAR2 IN DEFAULT
CAPTURE_USER VARCHAR2 IN DEFAULT
ENABLE_TRIGGER BOOLEAN IN DEFAULT
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.DROP_CAPTURE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CAPTURE_NAME VARCHAR2 IN
DROP_UNUSED_RULE_SETS BOOLEAN IN
CANON_INVOKER VARCHAR2 IN
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.DROP_CAPTURE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CAPTURE_NAME VARCHAR2 IN
CANON_INVOKER VARCHAR2 IN
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.ENFORCE_CHECKPOINT_RETENTION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CAPTURE_NAME VARCHAR2 IN
CKPT_PER_DAY NUMBER IN
ALL_CKPT_KEEP NUMBER IN
FUNCTION DBMS_CAPTURE_ADM_INTERNAL.GET_SOURCE_DATABASE RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_CAPTURE_NAME VARCHAR2 IN
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.INCLUDE_EXTRA_ATTRIBUTE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CAPTURE_NAME VARCHAR2 IN
ATTRIBUTE_NAME VARCHAR2 IN
INCLUDE BOOLEAN IN DEFAULT
FUNCTION DBMS_CAPTURE_ADM_INTERNAL.IS_CAPTURE_EXISTS RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_CAPTURE_NAME VARCHAR2 IN
FUNCTION DBMS_CAPTURE_ADM_INTERNAL.IS_DOWNSTREAM_CAPTURE RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_SOURCE_DATABASE_NAME VARCHAR2 IN
FUNCTION DBMS_CAPTURE_ADM_INTERNAL.IS_EXISTING_DOWNSTREAM_CAP RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_CAPTURE_NAME VARCHAR2 IN
FUNCTION DBMS_CAPTURE_ADM_INTERNAL.IS_SYNC_CAPTURE RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CAPTURE_NAME VARCHAR2 IN
IS_CANON_NAME BOOLEAN IN
FUNCTION DBMS_CAPTURE_ADM_INTERNAL.IS_USE_DBLINK RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_CAPTURE_NAME VARCHAR2 IN
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.PREPARE_DDL
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_NAME VARCHAR2 IN
SUPP_LOG_LEVEL BINARY_INTEGER IN
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.PREPARE_GLOBAL_INSTANTIATION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_INVOKER VARCHAR2 IN
SUPP_LOG_LEVEL BINARY_INTEGER IN
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.PREPARE_SCHEMA_INSTANTIATION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA_NAME VARCHAR2 IN
CANON_INVOKER VARCHAR2 IN
SUPP_LOG_LEVEL BINARY_INTEGER IN
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.PREPARE_SCHEMA_TABLES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_SCHEMA_NAME VARCHAR2 IN
FUNCTION DBMS_CAPTURE_ADM_INTERNAL.PREPARE_SYNC_INSTANTIATION RETURNS NUMBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TABLE_NAMES TABLE OF VARCHAR2(227) IN
CANON_INVOKER VARCHAR2 IN
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.PREPARE_TABLE_INST
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_OWNER VARCHAR2 IN
CANON_TABLE_NAME VARCHAR2 IN
SUPPLEMENTAL_LOGGING_LEVEL BINARY_INTEGER IN
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.PREPARE_TABLE_INSTANTIATION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TABLE_NAME VARCHAR2 IN
CANON_INVOKER VARCHAR2 IN
SUPP_LOG_LEVEL BINARY_INTEGER IN
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.REPLACE_DICTIONARY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SOURCE_DATABASE VARCHAR2 IN DEFAULT
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.STORE_PREPARE_INFO
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_NAME VARCHAR2 IN
SUPP_LOG_LEVEL BINARY_INTEGER IN
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.VALIDATE_PREPARE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CANON_OWNER VARCHAR2 IN
CANON_TABLE_NAME VARCHAR2 IN
PROCEDURE DBMS_CAPTURE_ADM_INTERNAL.WAIT_FOR_INFLIGHT_TXN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CURRENT_SCN NUMBER IN
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
