 |
|
DBMS_APPLY_ADM package tips
Oracle Tips by Burleson Consulting |
DBMS_APPLY_ADM
<< Return to the index
Related notes on DBMS_APPLY_ADM:
Oracle 11g provides the following information about the DBMS_APPLY_ADM package:
Description of the DBMS_APPLY_ADM package:
PROCEDURE DBMS_APPLY_ADM.ALTER_APPLY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
APPLY_NAME VARCHAR2 IN
RULE_SET_NAME VARCHAR2 IN DEFAULT
REMOVE_RULE_SET BOOLEAN IN DEFAULT
MESSAGE_HANDLER VARCHAR2 IN DEFAULT
REMOVE_MESSAGE_HANDLER BOOLEAN IN DEFAULT
DDL_HANDLER VARCHAR2 IN DEFAULT
REMOVE_DDL_HANDLER BOOLEAN IN DEFAULT
APPLY_USER VARCHAR2 IN DEFAULT
APPLY_TAG RAW IN DEFAULT
REMOVE_APPLY_TAG BOOLEAN IN DEFAULT
PRECOMMIT_HANDLER VARCHAR2 IN DEFAULT
REMOVE_PRECOMMIT_HANDLER BOOLEAN IN DEFAULT
NEGATIVE_RULE_SET_NAME VARCHAR2 IN DEFAULT
REMOVE_NEGATIVE_RULE_SET BOOLEAN IN DEFAULT
PROCEDURE DBMS_APPLY_ADM.COMPARE_OLD_VALUES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OBJECT_NAME VARCHAR2 IN
COLUMN_LIST VARCHAR2 IN
OPERATION VARCHAR2 IN DEFAULT
COMPARE BOOLEAN IN DEFAULT
APPLY_DATABASE_LINK VARCHAR2 IN DEFAULT
PROCEDURE DBMS_APPLY_ADM.COMPARE_OLD_VALUES
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OBJECT_NAME VARCHAR2 IN
COLUMN_TABLE TABLE OF VARCHAR2(4000) IN
OPERATION VARCHAR2 IN DEFAULT
COMPARE BOOLEAN IN DEFAULT
APPLY_DATABASE_LINK VARCHAR2 IN DEFAULT
PROCEDURE DBMS_APPLY_ADM.CREATE_APPLY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
QUEUE_NAME VARCHAR2 IN
APPLY_NAME VARCHAR2 IN
RULE_SET_NAME VARCHAR2 IN DEFAULT
MESSAGE_HANDLER VARCHAR2 IN DEFAULT
DDL_HANDLER VARCHAR2 IN DEFAULT
APPLY_USER VARCHAR2 IN DEFAULT
APPLY_DATABASE_LINK VARCHAR2 IN DEFAULT
APPLY_TAG RAW IN DEFAULT
APPLY_CAPTURED BOOLEAN IN DEFAULT
PRECOMMIT_HANDLER VARCHAR2 IN DEFAULT
NEGATIVE_RULE_SET_NAME VARCHAR2 IN DEFAULT
SOURCE_DATABASE VARCHAR2 IN DEFAULT
PROCEDURE DBMS_APPLY_ADM.CREATE_OBJECT_DEPENDENCY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OBJECT_NAME VARCHAR2 IN
PARENT_OBJECT_NAME VARCHAR2 IN
PROCEDURE DBMS_APPLY_ADM.DELETE_ALL_ERRORS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
APPLY_NAME VARCHAR2 IN DEFAULT
PROCEDURE DBMS_APPLY_ADM.DELETE_ERROR
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
LOCAL_TRANSACTION_ID VARCHAR2 IN
PROCEDURE DBMS_APPLY_ADM.DROP_APPLY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
APPLY_NAME VARCHAR2 IN
DROP_UNUSED_RULE_SETS BOOLEAN IN DEFAULT
PROCEDURE DBMS_APPLY_ADM.DROP_OBJECT_DEPENDENCY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OBJECT_NAME VARCHAR2 IN
PARENT_OBJECT_NAME VARCHAR2 IN
PROCEDURE DBMS_APPLY_ADM.EXECUTE_ALL_ERRORS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
APPLY_NAME VARCHAR2 IN DEFAULT
EXECUTE_AS_USER BOOLEAN IN DEFAULT
PROCEDURE DBMS_APPLY_ADM.EXECUTE_ERROR
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
LOCAL_TRANSACTION_ID VARCHAR2 IN
EXECUTE_AS_USER BOOLEAN IN DEFAULT
USER_PROCEDURE VARCHAR2 IN DEFAULT
FUNCTION DBMS_APPLY_ADM.GET_ERROR_MESSAGE RETURNS ANYDATA
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
MESSAGE_NUMBER NUMBER IN
LOCAL_TRANSACTION_ID VARCHAR2 IN
FUNCTION DBMS_APPLY_ADM.GET_ERROR_MESSAGE RETURNS ANYDATA
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
MESSAGE_NUMBER NUMBER IN
LOCAL_TRANSACTION_ID VARCHAR2 IN
DESTINATION_QUEUE_NAME VARCHAR2 OUT
EXECUTE BOOLEAN OUT
PROCEDURE DBMS_APPLY_ADM.SET_DML_HANDLER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OBJECT_NAME VARCHAR2 IN
OBJECT_TYPE VARCHAR2 IN
OPERATION_NAME VARCHAR2 IN
ERROR_HANDLER BOOLEAN IN DEFAULT
USER_PROCEDURE VARCHAR2 IN
APPLY_DATABASE_LINK VARCHAR2 IN DEFAULT
APPLY_NAME VARCHAR2 IN DEFAULT
ASSEMBLE_LOBS BOOLEAN IN DEFAULT
PROCEDURE DBMS_APPLY_ADM.SET_ENQUEUE_DESTINATION
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
RULE_NAME VARCHAR2 IN
DESTINATION_QUEUE_NAME VARCHAR2 IN
PROCEDURE DBMS_APPLY_ADM.SET_EXECUTE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
RULE_NAME VARCHAR2 IN
EXECUTE BOOLEAN IN
PROCEDURE DBMS_APPLY_ADM.SET_GLOBAL_INSTANTIATION_SCN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SOURCE_DATABASE_NAME VARCHAR2 IN
INSTANTIATION_SCN NUMBER IN
APPLY_DATABASE_LINK VARCHAR2 IN DEFAULT
RECURSIVE BOOLEAN IN DEFAULT
PROCEDURE DBMS_APPLY_ADM.SET_KEY_COLUMNS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OBJECT_NAME VARCHAR2 IN
COLUMN_LIST VARCHAR2 IN
APPLY_DATABASE_LINK VARCHAR2 IN DEFAULT
PROCEDURE DBMS_APPLY_ADM.SET_KEY_COLUMNS
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OBJECT_NAME VARCHAR2 IN
COLUMN_TABLE TABLE OF VARCHAR2(30) IN
APPLY_DATABASE_LINK VARCHAR2 IN DEFAULT
PROCEDURE DBMS_APPLY_ADM.SET_PARAMETER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
APPLY_NAME VARCHAR2 IN
PARAMETER VARCHAR2 IN
VALUE VARCHAR2 IN
PROCEDURE DBMS_APPLY_ADM.SET_SCHEMA_INSTANTIATION_SCN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SOURCE_SCHEMA_NAME VARCHAR2 IN
SOURCE_DATABASE_NAME VARCHAR2 IN
INSTANTIATION_SCN NUMBER IN
APPLY_DATABASE_LINK VARCHAR2 IN DEFAULT
RECURSIVE BOOLEAN IN DEFAULT
PROCEDURE DBMS_APPLY_ADM.SET_TABLE_INSTANTIATION_SCN
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SOURCE_OBJECT_NAME VARCHAR2 IN
SOURCE_DATABASE_NAME VARCHAR2 IN
INSTANTIATION_SCN NUMBER IN
APPLY_DATABASE_LINK VARCHAR2 IN DEFAULT
PROCEDURE DBMS_APPLY_ADM.SET_UPDATE_CONFLICT_HANDLER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OBJECT_NAME VARCHAR2 IN
METHOD_NAME VARCHAR2 IN
RESOLUTION_COLUMN VARCHAR2 IN
COLUMN_LIST TABLE OF VARCHAR2(30) IN
APPLY_DATABASE_LINK VARCHAR2 IN DEFAULT
PROCEDURE DBMS_APPLY_ADM.SET_VALUE_DEPENDENCY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
DEPENDENCY_NAME VARCHAR2 IN
OBJECT_NAME VARCHAR2 IN
ATTRIBUTE_TABLE TABLE OF VARCHAR2(30) IN
PROCEDURE DBMS_APPLY_ADM.SET_VALUE_DEPENDENCY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
DEPENDENCY_NAME VARCHAR2 IN
OBJECT_NAME VARCHAR2 IN
ATTRIBUTE_LIST VARCHAR2 IN
PROCEDURE DBMS_APPLY_ADM.START_APPLY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
APPLY_NAME VARCHAR2 IN
PROCEDURE DBMS_APPLY_ADM.STOP_APPLY
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
APPLY_NAME VARCHAR2 IN
FORCE BOOLEAN 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
|
|
