 |
|
DBMS_CDC_UTILITY package tips
Oracle Tips by Burleson Consulting |
DBMS_CDC_UTILITY
<< Return to the index
Related notes on DBMS_CDC_UTILITY:
Oracle 11g provides the following information about the DBMS_CDC_UTILITY package:
Description of the DBMS_CDC_UTILITY package:
PROCEDURE DBMS_CDC_UTILITY.CDC_ALLOCATE_LOCK
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
LOCKNAME VARCHAR2 IN
LOCKHANDLE VARCHAR2 OUT
EXPIRATION_SECS NUMBER(38) IN DEFAULT
FUNCTION DBMS_CDC_UTILITY.CHECK_PURGE RETURNS BOOLEAN
PROCEDURE DBMS_CDC_UTILITY.CHK_SECURITY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
OWNERL BINARY_INTEGER IN
TABLE_NAME VARCHAR2 IN
TABLE_NAMEL BINARY_INTEGER IN
MVLOG BINARY_INTEGER IN
SUCCESS BINARY_INTEGER OUT
PROCEDURE DBMS_CDC_UTILITY.CLEANUP_SYNC_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
TABLE_NAME VARCHAR2 IN
PROCEDURE DBMS_CDC_UTILITY.COUNT_EXISTING_COL
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TABOBJN BINARY_INTEGER IN
COLNAM VARCHAR2 IN
COUNT BINARY_INTEGER OUT
PROCEDURE DBMS_CDC_UTILITY.COUNT_OBJECT_COL
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
TABNAM VARCHAR2 IN
COUNT BINARY_INTEGER OUT
PROCEDURE DBMS_CDC_UTILITY.COUNT_PURGE_JOB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PURGE_JOB VARCHAR2 IN
JOB_CNT BINARY_INTEGER OUT
PROCEDURE DBMS_CDC_UTILITY.COUNT_SUBSCRIBERS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_TABLE_OBJN BINARY_INTEGER IN
NUM_OF_SUBSCRIBERS BINARY_INTEGER OUT
PROCEDURE DBMS_CDC_UTILITY.DELETE_EXPORT_ACTION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_TABLE_OWNER VARCHAR2 IN
CHANGE_TABLE_NAME VARCHAR2 IN
PROCEDURE DBMS_CDC_UTILITY.DROP_USER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
USER_NAME VARCHAR2 IN
FUNCTION DBMS_CDC_UTILITY.EXPORT_CHANGE_TABLE RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA_COMMA_TABLE VARCHAR2 IN
PROCEDURE DBMS_CDC_UTILITY.EXTEND_WINDOW_LIST
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SUBSCRIPTION_LIST VARCHAR2 IN
SOURCE_SCHEMA_LIST VARCHAR2 IN
SOURCE_TABLE_LIST VARCHAR2 IN
ROLLBACK_SEGMENT_LIST VARCHAR2 IN
CHECK_SOURCE BOOLEAN IN
READ_CONSISTENCY BOOLEAN IN
TIMESTAMP_SCN_LIST VARCHAR2 OUT
TABLEMOD_SCN_LIST VARCHAR2 OUT
READ_CONSISTENT_SCN NUMBER OUT
PROCEDURE DBMS_CDC_UTILITY.FIXUP_SYNC_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
TABLE_NAME VARCHAR2 IN
FUNCTION DBMS_CDC_UTILITY.GETSYNCSCN RETURNS NUMBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
HIGHEST_SCN NUMBER IN
HIGHEST_LEN NUMBER IN
FUNCTION DBMS_CDC_UTILITY.GET_CURRENT_SCN RETURNS NUMBER
FUNCTION DBMS_CDC_UTILITY.GET_EVENT_LEVEL RETURNS NUMBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
EVENT NUMBER IN
PROCEDURE DBMS_CDC_UTILITY.GET_INSTANCE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
MAJOR_VERSION NUMBER OUT
MINOR_VERSION NUMBER OUT
DB_NAME VARCHAR2 OUT
FUNCTION DBMS_CDC_UTILITY.GET_ORACLE_EDITION RETURNS NUMBER
PROCEDURE DBMS_CDC_UTILITY.GET_TABLE_OBJN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
TABNAM VARCHAR2 IN
TABOBJN BINARY_INTEGER OUT
PROCEDURE DBMS_CDC_UTILITY.IMPORT_CHANGE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_TABLE_TYPE VARCHAR2 IN
MAJOR_VERSION VARCHAR2 IN
MINOR_VERSION VARCHAR2 IN
DATABASE_NAME VARCHAR2 IN
OWNER VARCHAR2 IN
CHANGE_TABLE_NAME VARCHAR2 IN
CHANGE_SET_NAME VARCHAR2 IN
SOURCE_SCHEMA VARCHAR2 IN
SOURCE_TABLE VARCHAR2 IN
CREATED_SCN VARCHAR2 IN
LOWEST_SCN VARCHAR2 IN
HIGHEST_SCN VARCHAR2 IN
COLUMN_TYPE_LIST VARCHAR2 IN
COL_CREATED VARCHAR2 IN
CAPTURE_VALUES VARCHAR2 IN
RS_ID CHAR IN
ROW_ID CHAR IN
USER_ID CHAR IN
TIMESTAMP CHAR IN
OBJECT_ID CHAR IN
SOURCE_COLMAP CHAR IN
TARGET_COLMAP CHAR IN
DDL_MARKERS CHAR IN
OPT_CREATED VARCHAR2 IN
FUNCTION DBMS_CDC_UTILITY.IS_CONTROL_COLUMN RETURNS NUMBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
COLUMN_NAME VARCHAR2 IN
FUNCTION DBMS_CDC_UTILITY.IS_CONTROL_COLUMNMV RETURNS NUMBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
COLUMN_NAME VARCHAR2 IN
PROCEDURE DBMS_CDC_UTILITY.LOCK_CHANGE_SET
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_SET_NAME VARCHAR2 IN
FUNCTION DBMS_CDC_UTILITY.NUMTOHEX RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NUM NUMBER IN
PROCEDURE DBMS_CDC_UTILITY.PURGEMVLOGLOGICAL
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SUBSCRIPTION_HANDLE NUMBER IN
PURGE_THIS_SUBSCRIPTION CHAR IN
UPDATED_SOMETHING NUMBER OUT
PROCEDURE DBMS_CDC_UTILITY.PURGEMVLOGPHYSICAL
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA_NAME VARCHAR2 IN
TABLE_NAME VARCHAR2 IN
ROWS_PURGED NUMBER OUT
PROCEDURE DBMS_CDC_UTILITY.QCCGELVL
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
EVENT BINARY_INTEGER IN
LEVEL BINARY_INTEGER OUT
PROCEDURE DBMS_CDC_UTILITY.QCCGETEE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
EDITION_O BINARY_INTEGER OUT
PROCEDURE DBMS_CDC_UTILITY.QCCGSCN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCNBASE_O BINARY_INTEGER OUT
SCNWRAP_O BINARY_INTEGER OUT
PROCEDURE DBMS_CDC_UTILITY.QCCSGNBS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
HIGHEST_SCN NUMBER IN
HIGHEST_LEN BINARY_INTEGER IN
NEXT_SCN NUMBER OUT
PROCEDURE DBMS_CDC_UTILITY.SETUP_SYNC_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
TABLE_NAME VARCHAR2 IN
PROCEDURE DBMS_CDC_UTILITY.SET_PURGEBOUNDARY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SUBSCRIPTION_HANDLE BINARY_INTEGER IN
PROCEDURE DBMS_CDC_UTILITY.SET_WINDOW_START
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SUBSCRIPTION_HANDLE NUMBER IN
PROCEDURE DBMS_CDC_UTILITY.VERIFY_VARCHAR_PARAM
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
PARAM_NAME VARCHAR2 IN
PARAM_VALUE VARCHAR2 IN
PARAM_MAX BINARY_INTEGER 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
|
|
