Call (800) 766-1884 for Oracle support & training
Free Oracle Tips


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 

HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Redneck
 

 

   
 

DBMS_CDC_DPUTIL package tips

Oracle Tips by Burleson Consulting

DBMS_CDC_DPUTIL

<< Return to the index

Related notes on DBMS_CDC_DPUTIL:


Oracle 11g provides the following information about the DBMS_CDC_DPUTIL package:

Description of the DBMS_CDC_DPUTIL package:



FUNCTION DBMS_CDC_DPUTIL.CDC_OBJECTS_TO_EXPORT RETURNS BOOLEAN
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SCHEMA                         VARCHAR2                IN

FUNCTION DBMS_CDC_DPUTIL.ERROR_TEXT RETURNS VARCHAR2
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 MESSAGE_NUM                    NUMBER                  IN
 PARAMETER1                     VARCHAR2                IN     DEFAULT
 PARAMETER2                     VARCHAR2                IN     DEFAULT
 PARAMETER3                     VARCHAR2                IN     DEFAULT
 PARAMETER4                     VARCHAR2                IN     DEFAULT
 PARAMETER5                     VARCHAR2                IN     DEFAULT
 PARAMETER6                     VARCHAR2                IN     DEFAULT
 PARAMETER7                     VARCHAR2                IN     DEFAULT
 PARAMETER8                     VARCHAR2                IN     DEFAULT

PROCEDURE DBMS_CDC_DPUTIL.GET_ERROR_TEXT
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 ERROR_NUMBER                   BINARY_INTEGER          IN
 PARAMETER1                     VARCHAR2                IN
 PARAMETER2                     VARCHAR2                IN
 PARAMETER3                     VARCHAR2                IN
 PARAMETER4                     VARCHAR2                IN
 PARAMETER5                     VARCHAR2                IN
 PARAMETER6                     VARCHAR2                IN
 PARAMETER7                     VARCHAR2                IN
 PARAMETER8                     VARCHAR2                IN
 MESSAGE_BUFFER                 VARCHAR2                IN/OUT

PROCEDURE DBMS_CDC_DPUTIL.GET_IMPVLDTAB_NAME
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 IMPVLDTAB_NAME                 VARCHAR2                OUT

FUNCTION DBMS_CDC_DPUTIL.GET_JOB_DESC RETURNS KU$_JOBDESC

PROCEDURE DBMS_CDC_DPUTIL.GET_TABVIEW_OBJNO
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 TABVIEW_OWNER                  VARCHAR2                IN
 TABVIEW_NAME                   VARCHAR2                IN
 OBJECT_NUMBER                  BINARY_INTEGER          OUT

FUNCTION DBMS_CDC_DPUTIL.IS_FULL_DB_EXPORT RETURNS BOOLEAN

FUNCTION DBMS_CDC_DPUTIL.VALID_TABLE RETURNS BOOLEAN
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 OWNER                          VARCHAR2                IN
 TABLE_NAME                     VARCHAR2                IN
 VER_OWNER                      VARCHAR2                OUT
 VER_TABLE                      VARCHAR2                OUT

PROCEDURE DBMS_CDC_DPUTIL.WRITE_LOG
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 MESSAGE                        VARCHAR2                IN
 TIME_INFO                      BOOLEAN                 IN     DEFAULT

PROCEDURE DBMS_CDC_DPUTIL.WRITE_TRACE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 MESSAGE                        VARCHAR2                IN
 TIME_INFO                      BOOLEAN                 IN

PROCEDURE DBMS_CDC_DPUTIL.WRITE_TRACE
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 MESSAGE                        VARCHAR2                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

 

  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 

   

Copyright © 1996 -  2009 by Burleson Enterprises, Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.