 |
|
DBMS_CDC_ISUBSCRIBE package tips
Oracle Tips by Burleson Consulting |
DBMS_CDC_ISUBSCRIBE
<< Return to the index
Related notes on DBMS_CDC_ISUBSCRIBE:
Oracle 11g provides the following information about the DBMS_CDC_ISUBSCRIBE package:
Description of the DBMS_CDC_ISUBSCRIBE package:
PROCEDURE DBMS_CDC_ISUBSCRIBE.CREATE_SUBSCRIPTION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_SET_NAME VARCHAR2 IN
DESCRIPTION VARCHAR2 IN
SUBSCRIPTION_NAME VARCHAR2 IN/OUT
PROCEDURE DBMS_CDC_ISUBSCRIBE.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 CHAR IN
READ_CONSISTENCY CHAR IN
TIMESTAMP_SCN_LIST VARCHAR2 OUT
TABLEMOD_SCN_LIST VARCHAR2 OUT
READ_CONSISTENT_SCN NUMBER OUT
PROCEDURE DBMS_CDC_ISUBSCRIBE.INT_EXTEND_WINDOW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SUBSCRIPTION_NAME VARCHAR2 IN
UPPER_BOUND DATE IN
PROCEDURE DBMS_CDC_ISUBSCRIBE.INT_PURGE_WINDOW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SUBSCRIPTION_NAME VARCHAR2 IN
LOWER_BOUND DATE IN
PROCEDURE DBMS_CDC_ISUBSCRIBE.PREPARE_UNBOUNDED_VIEW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SUBSCRIPTION_HANDLE NUMBER IN
SOURCE_SCHEMA VARCHAR2 IN
SOURCE_TABLE VARCHAR2 IN
VIEW_NAME VARCHAR2 OUT
PROCEDURE DBMS_CDC_ISUBSCRIBE.SUBSCRIBE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SUBSCRIPTION_NAME VARCHAR2 IN
SOURCE_SCHEMA VARCHAR2 IN
SOURCE_TABLE VARCHAR2 IN
COLUMN_LIST VARCHAR2 IN
SUBSCRIBER_VIEW VARCHAR2 IN/OUT
PROCEDURE DBMS_CDC_ISUBSCRIBE.SUBSCRIBE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SUBSCRIPTION_NAME VARCHAR2 IN
PUBLICATION_ID NUMBER IN
COLUMN_LIST VARCHAR2 IN
SUBSCRIBER_VIEW VARCHAR2 IN/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
|
|
