 |
|
DBMS_CDC_IPUBLISH package tips
Oracle Tips by Burleson Consulting |
DBMS_CDC_IPUBLISH
<< Return to the index
Related notes on DBMS_CDC_IPUBLISH:
Oracle 11g provides the following information about the DBMS_CDC_IPUBLISH package:
Description of the DBMS_CDC_IPUBLISH package:
PROCEDURE DBMS_CDC_IPUBLISH.ALTER_HOTLOG_INTERNAL_CSOURCE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_SOURCE_NAME VARCHAR2 IN
DESCRIPTION VARCHAR2 IN DEFAULT
REMOVE_DESCRIPTION CHAR IN DEFAULT
ENABLE_SOURCE CHAR IN DEFAULT
PROCEDURE DBMS_CDC_IPUBLISH.ALTER_INT_CHANGE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
CHANGE_TABLE_NAME VARCHAR2 IN
OPERATION VARCHAR2 IN
COLUMN_LIST 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
PROCEDURE DBMS_CDC_IPUBLISH.CHANGE_TABLE_TRIGGER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA VARCHAR2 IN
TABLENAME VARCHAR2 IN
OPERATION VARCHAR2 IN
PROCEDURE DBMS_CDC_IPUBLISH.CHECK_10GR2_COMPATIBILITY
PROCEDURE DBMS_CDC_IPUBLISH.CHECK_PUBLISHER_REQ
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
USER_NAME VARCHAR2 IN
OK BINARY_INTEGER OUT
FUNCTION DBMS_CDC_IPUBLISH.CHECK_REMOTE_USER_ROLE_PRIV RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
REMOTE_DBLINK VARCHAR2 IN
ROLE VARCHAR2 IN
FUNCTION DBMS_CDC_IPUBLISH.CHECK_USER_ROLE_PRIV RETURNS BOOLEAN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
USER VARCHAR2 IN
ROLE VARCHAR2 IN
PROCEDURE DBMS_CDC_IPUBLISH.CHGTAB_CACHE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_SET_NAME VARCHAR2 IN
OWNER VARCHAR2 IN
CHANGE_TABLE_NAME VARCHAR2 IN
OPERATION VARCHAR2 IN
PROCEDURE DBMS_CDC_IPUBLISH.CREATE_CHANGE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
CHANGE_TABLE_NAME VARCHAR2 IN
CHANGE_SET_NAME VARCHAR2 IN
SOURCE_SCHEMA VARCHAR2 IN
SOURCE_TABLE VARCHAR2 IN
COLUMN_TYPE_LIST 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
OPTIONS_STRING VARCHAR2 IN
GCR NUMBER IN
PROCEDURE DBMS_CDC_IPUBLISH.CREATE_CHGTAB_STRUCT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
CHANGE_TABLE_NAME VARCHAR2 IN
PROCEDURE DBMS_CDC_IPUBLISH.CREATE_HOTLOG_INTERNAL_CSOURCE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_SOURCE_NAME VARCHAR2 IN
DESCRIPTION VARCHAR2 IN DEFAULT
SOURCE_TYPE BINARY_INTEGER IN
SOURCE_DATABASE VARCHAR2 IN
PROCEDURE DBMS_CDC_IPUBLISH.CREATE_HOTLOG_INTERNAL_PROP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_SOURCE_NAME VARCHAR2 IN
CHANGE_SET_PUBLISHER VARCHAR2 IN
CHANGE_SET_NAME VARCHAR2 IN
DESTQUEUE_PUBLISHER VARCHAR2 IN
DESTQUEUE_NAME VARCHAR2 IN
STAGING_DATABASE VARCHAR2 IN
SOURCE_CLASS BINARY_INTEGER IN
PROCEDURE DBMS_CDC_IPUBLISH.CREATE_INT_CHANGE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
CHANGE_TABLE_NAME VARCHAR2 IN
CHANGE_SET_NAME VARCHAR2 IN
SOURCE_SCHEMA VARCHAR2 IN
SOURCE_TABLE VARCHAR2 IN
COLUMN_TYPE_LIST 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
OPTIONS_STRING VARCHAR2 IN
PROCEDURE DBMS_CDC_IPUBLISH.CREATE_MAP_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_SET_NAME VARCHAR2 IN
PROCEDURE DBMS_CDC_IPUBLISH.DROP_CHGTAB_STRUCT
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
CHANGE_TABLE_NAME VARCHAR2 IN
PROCEDURE DBMS_CDC_IPUBLISH.DROP_HOTLOG_INTERNAL_CSOURCE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_SOURCE_NAME VARCHAR2 IN
PROCEDURE DBMS_CDC_IPUBLISH.DROP_HOTLOG_INTERNAL_PROP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_SOURCE_NAME VARCHAR2 IN
CHANGE_SET_PUBLISHER VARCHAR2 IN
CHANGE_SET_NAME VARCHAR2 IN
STAGING_DATABASE VARCHAR2 IN
CHANGE_SOURCE_TYPE BINARY_INTEGER IN
PROCEDURE DBMS_CDC_IPUBLISH.GET_DATABASE_VERSION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SOURCE_DATABASE VARCHAR2 IN
VER9 BOOLEAN IN/OUT
VER101 BOOLEAN IN/OUT
VER102 BOOLEAN IN/OUT
VER111 BOOLEAN IN/OUT
PROCEDURE DBMS_CDC_IPUBLISH.INSERT_MESSAGE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
MESSAGE VARCHAR2 IN
PROCEDURE DBMS_CDC_IPUBLISH.INSERT_MESSAGE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
MESSAGE VARCHAR2 IN
FLAG BOOLEAN IN
PROCEDURE DBMS_CDC_IPUBLISH.IS_COLUMN_ENCRYPTED
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TABLE_OBJ_NUM BINARY_INTEGER IN
COLUMN_NAME VARCHAR2 IN
PROCEDURE DBMS_CDC_IPUBLISH.PURGE_LOGICAL_SUB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SUBSCRIPTION_HANDLE NUMBER IN
PURGE_THIS_SUBSCRIPTION CHAR IN
UPDATED_SOMETHING BINARY_INTEGER OUT
PROCEDURE DBMS_CDC_IPUBLISH.RESOLVE_DBLINK_USER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
DBLINK VARCHAR2 IN
PUB_REMOTE VARCHAR2 IN/OUT
FUNCTION DBMS_CDC_IPUBLISH.TRACE_DEBUG RETURNS BOOLEAN
PROCEDURE DBMS_CDC_IPUBLISH.UPGRADE_METADATA_TO_10GR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_SOURCE_NAME VARCHAR2 IN
SOURCE_DATABASE VARCHAR2 IN
PROCEDURE DBMS_CDC_IPUBLISH.VERIFY_DBLINK
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
DBLINK VARCHAR2 IN
VERIFIED_DBLINK VARCHAR2 OUT
 |
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
|
|
