Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_APPLY Details about each apply process that dequeues from the queue visible to the current user

Column ID Column name Data type Length Precision NULL Description
1APPLY_NAMEVARCHAR230(null)NName of the apply process
2QUEUE_NAMEVARCHAR230(null)NName of the queue the apply process dequeues from
3QUEUE_OWNERVARCHAR230(null)NOwner of the queue the apply process dequeues from
4APPLY_CAPTUREDVARCHAR23(null)YYes, if applying captured messages; No, if applying enqueued messages
5RULE_SET_NAMEVARCHAR230(null)YRule set used by apply process for filtering
6RULE_SET_OWNERVARCHAR230(null)YOwner of the rule set
7APPLY_USERVARCHAR230(null)YCurrent user who is applying the messages
8APPLY_DATABASE_LINKVARCHAR2128(null)YFor remote objects, the database link pointing to the remote database
9APPLY_TAGRAW2000(null)YTag associated with DDL and DML change records that will be applied
10DDL_HANDLERVARCHAR298(null)YName of the user specified ddl handler
11PRECOMMIT_HANDLERVARCHAR298(null)YName of the user specified precommit handler
12MESSAGE_HANDLERVARCHAR298(null)YUser specified procedure to handle messages other than DDL and DML messages
13STATUSVARCHAR28(null)YStatus of the apply process: DISABLED, ENABLED, ABORTED
14MAX_APPLIED_MESSAGE_NUMBERNUMBER22(null)YMaximum value of message that has been applied
15NEGATIVE_RULE_SET_NAMEVARCHAR230(null)YNegative rule set used by apply process for filtering
16NEGATIVE_RULE_SET_OWNERVARCHAR230(null)YOwner of the negative rule set
17STATUS_CHANGE_TIMEDATE7(null)YThe time that STATUS of the apply process was changed
18ERROR_NUMBERNUMBER22(null)YError number if the apply process was aborted
19ERROR_MESSAGEVARCHAR24000(null)YError message if the apply process was aborted
20MESSAGE_DELIVERY_MODEVARCHAR210(null)YNULL - oracleabc.com

Index | Home | Forums

This page was created by oracleabc.com on Dec 31,2007 18:49:14
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here