 |
|
DBMS_CDC_PUBLISH package tips
Oracle Tips by Burleson Consulting |
DBMS_CDC_PUBLISH
<< Return to the index
Related notes on DBMS_CDC_PUBLISH:
Oracle 11g provides the following information about the DBMS_CDC_PUBLISH package:
Description of the DBMS_CDC_PUBLISH package:
PROCEDURE DBMS_CDC_PUBLISH.ALTER_AUTOLOG_CHANGE_SOURCE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_SOURCE_NAME VARCHAR2 IN
DESCRIPTION VARCHAR2 IN DEFAULT
REMOVE_DESCRIPTION CHAR IN DEFAULT
FIRST_SCN NUMBER IN DEFAULT
PROCEDURE DBMS_CDC_PUBLISH.ALTER_CHANGE_SET
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_SET_NAME VARCHAR2 IN
DESCRIPTION VARCHAR2 IN DEFAULT
REMOVE_DESCRIPTION CHAR IN DEFAULT
ENABLE_CAPTURE CHAR IN DEFAULT
RECOVER_AFTER_ERROR CHAR IN DEFAULT
REMOVE_DDL CHAR IN DEFAULT
STOP_ON_DDL CHAR IN DEFAULT
PROCEDURE DBMS_CDC_PUBLISH.ALTER_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 DEFAULT
PROCEDURE DBMS_CDC_PUBLISH.ALTER_HOTLOG_CHANGE_SOURCE
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_PUBLISH.CREATE_AUTOLOG_CHANGE_SOURCE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_SOURCE_NAME VARCHAR2 IN
DESCRIPTION VARCHAR2 IN DEFAULT
SOURCE_DATABASE VARCHAR2 IN
FIRST_SCN NUMBER IN
ONLINE_LOG CHAR IN DEFAULT
PROCEDURE DBMS_CDC_PUBLISH.CREATE_CHANGE_SET
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_SET_NAME VARCHAR2 IN
DESCRIPTION VARCHAR2 IN DEFAULT
CHANGE_SOURCE_NAME VARCHAR2 IN
STOP_ON_DDL CHAR IN DEFAULT
BEGIN_DATE DATE IN DEFAULT
END_DATE DATE IN DEFAULT
PROCEDURE DBMS_CDC_PUBLISH.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
DDL_MARKERS CHAR IN DEFAULT
PROCEDURE DBMS_CDC_PUBLISH.CREATE_HOTLOG_CHANGE_SOURCE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_SOURCE_NAME VARCHAR2 IN
DESCRIPTION VARCHAR2 IN DEFAULT
SOURCE_DATABASE VARCHAR2 IN
PROCEDURE DBMS_CDC_PUBLISH.DROP_CHANGE_SET
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_SET_NAME VARCHAR2 IN
PROCEDURE DBMS_CDC_PUBLISH.DROP_CHANGE_SOURCE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_SOURCE_NAME VARCHAR2 IN
PROCEDURE DBMS_CDC_PUBLISH.DROP_CHANGE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
CHANGE_TABLE_NAME VARCHAR2 IN
FORCE_FLAG CHAR IN
PROCEDURE DBMS_CDC_PUBLISH.DROP_SUBSCRIBER_VIEW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SUBSCRIPTION_HANDLE NUMBER IN
SOURCE_SCHEMA VARCHAR2 IN
SOURCE_TABLE VARCHAR2 IN
PROCEDURE DBMS_CDC_PUBLISH.DROP_SUBSCRIPTION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SUBSCRIPTION_NAME VARCHAR2 IN
PROCEDURE DBMS_CDC_PUBLISH.DROP_SUBSCRIPTION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SUBSCRIPTION_HANDLE NUMBER IN
FUNCTION DBMS_CDC_PUBLISH.GET_DDLOPER RETURNS VARCHAR2
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
DDLOPER BINARY_INTEGER IN
PROCEDURE DBMS_CDC_PUBLISH.PURGE
PROCEDURE DBMS_CDC_PUBLISH.PURGE_CHANGE_SET
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_SET_NAME VARCHAR2 IN
FORCE CHAR IN DEFAULT
PURGE_DATE DATE IN DEFAULT
PROCEDURE DBMS_CDC_PUBLISH.PURGE_CHANGE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 IN
CHANGE_TABLE_NAME VARCHAR2 IN
FORCE CHAR IN DEFAULT
PURGE_DATE DATE IN DEFAULT
 |
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
|
|
