 |
|
DBMS_CDC_SYS_IPUBLISH package tips
Oracle Tips by Burleson Consulting |
DBMS_CDC_SYS_IPUBLISH
<< Return to the index
Oracle 11g provides the following information about the DBMS_CDC_SYS_IPUBLISH package:
Description of the DBMS_CDC_SYS_IPUBLISH package:
PROCEDURE DBMS_CDC_SYS_IPUBLISH.COUNT_CHANGE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NONMVLONLY BINARY_INTEGER IN
COUNT BINARY_INTEGER OUT
PROCEDURE DBMS_CDC_SYS_IPUBLISH.DROP_SUBSCRIBER_VIEW
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SUBSCRIPTION_HANDLE NUMBER IN
SOURCE_SCHEMA VARCHAR2 IN
SOURCE_TABLE VARCHAR2 IN
PROCEDURE DBMS_CDC_SYS_IPUBLISH.DROP_SUBSCRIPTION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SUBSCRIPTION_NAME VARCHAR2 IN
PROCEDURE DBMS_CDC_SYS_IPUBLISH.DROP_SUBSCRIPTION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SUBSCRIPTION_HANDLE NUMBER IN
PROCEDURE DBMS_CDC_SYS_IPUBLISH.ENABLE_TABLE_TRIGGER
PROCEDURE DBMS_CDC_SYS_IPUBLISH.GET_CHANGE_TABLE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_TABLE_NAME VARCHAR2 IN
CHANGE_TABLE_SCHEMA VARCHAR2 IN
LOCKED BINARY_INTEGER IN
CHANGE_SET_NAME VARCHAR2 OUT
SOURCE_SCHEMA_NAME VARCHAR2 OUT
SOURCE_TABLE_NAME VARCHAR2 OUT
CREATED DATE OUT
CREATED_SCN NUMBER OUT
MVL_FLAG NUMBER OUT
CAPTURED_VALUES VARCHAR2 OUT
MVL_TEMP_LOG VARCHAR2 OUT
MVL_V7TRIGGER VARCHAR2 OUT
LAST_ALTERED DATE OUT
LOWEST_SCN NUMBER OUT
HIGHEST_SCN NUMBER OUT
CHANGE_TABLE_TYPE NUMBER OUT
MAJOR_VERSION NUMBER OUT
MINOR_VERSION NUMBER OUT
CHANGE_TABLE_OBJN NUMBER OUT
PROCEDURE DBMS_CDC_SYS_IPUBLISH.GET_CHGSRC_METADATA
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRCNAM VARCHAR2 IN
CAPNAM VARCHAR2 OUT
CAPQUE VARCHAR2 OUT
CAPTAB VARCHAR2 OUT
PROCEDURE DBMS_CDC_SYS_IPUBLISH.GET_CHGSRC_TYPE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SET_NAME VARCHAR2 IN
SRCTYPE BINARY_INTEGER OUT
DIST BINARY_INTEGER OUT
DBVER BINARY_INTEGER OUT
PROCEDURE DBMS_CDC_SYS_IPUBLISH.GET_FRESHNESS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CSET VARCHAR2 IN
FRESH NUMBER OUT
PROCEDURE DBMS_CDC_SYS_IPUBLISH.INSERT_CHGSRC_DATA
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
VER9 BOOLEAN IN
VER101 BOOLEAN IN
VER102 BOOLEAN IN
SRCNAM VARCHAR2 IN
SRCDSC VARCHAR2 IN
CAP_NAME VARCHAR2 IN
CAP_QUEUE VARCHAR2 IN
CAP_QUETAB VARCHAR2 IN
SRCDB VARCHAR2 IN
PUB_REMOTE VARCHAR2 IN
PUB_LOCAL VARCHAR2 IN DEFAULT
CREATED DATE IN DEFAULT
SRCTYP BINARY_INTEGER IN DEFAULT
SRCENA VARCHAR2 IN DEFAULT
PROCEDURE DBMS_CDC_SYS_IPUBLISH.RAISE_SYSTEM_ERROR
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NUM BINARY_INTEGER IN
ARG1 VARCHAR2 IN DEFAULT
ARG2 VARCHAR2 IN DEFAULT
ARG3 VARCHAR2 IN DEFAULT
PROCEDURE DBMS_CDC_SYS_IPUBLISH.REMOVE_CHGSET_PROP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRC_NAME VARCHAR2 IN
SET_NAME VARCHAR2 IN
SET_PUB VARCHAR2 IN
STAGE_DB VARCHAR2 IN
PROCEDURE DBMS_CDC_SYS_IPUBLISH.REMOVE_CHGTAB
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
CHANGE_TABLE_OBJN NUMBER IN
PROCEDURE DBMS_CDC_SYS_IPUBLISH.REMOVE_CHGTAB_METADATA
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OBJNUM BINARY_INTEGER IN
PROCEDURE DBMS_CDC_SYS_IPUBLISH.REMOVE_SUBSCRIPTION_METADATA
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SUBSCRIPTION_HANDLE BINARY_INTEGER IN
PROCEDURE DBMS_CDC_SYS_IPUBLISH.REUSE_CHGSET_PROP
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SRC_NAME VARCHAR2 IN
STAGE_DB VARCHAR2 IN
DSTQUE_PUB VARCHAR2 IN
DSTQUE_NAME VARCHAR2 IN
SET_NAME VARCHAR2 IN
SET_PUB VARCHAR2 IN
PROCEDURE DBMS_CDC_SYS_IPUBLISH.UPDATE_CDC_PROP_TABLES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TAB_NAME VARCHAR2 IN
DML_TYPE VARCHAR2 IN
SRC_NAME VARCHAR2 IN
PROP_NAME VARCHAR2 IN
STAGE_DB VARCHAR2 IN
DSTQUE_PUB VARCHAR2 IN
DSTQUE_NAME VARCHAR2 IN
SET_NAME VARCHAR2 IN
SET_PUB VARCHAR2 IN
SRC_CLASS BINARY_INTEGER IN
PROCEDURE DBMS_CDC_SYS_IPUBLISH.UPDATE_CHGSRC_METADATA
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
REMOVE_DESCRIPTION CHAR IN
DESCRIPTION VARCHAR2 IN
ENABLE_SOURCE CHAR IN
SOURCE_TYPE BINARY_INTEGER IN
SOURCE_NAME VARCHAR2 IN
PROCEDURE DBMS_CDC_SYS_IPUBLISH.UPDATE_SUBSCRIBED_TAB_STATUS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SUBSCRIPTION_HANDLE BINARY_INTEGER IN
CHGTAB BINARY_INTEGER IN
STATUS CHAR 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
|
|
