[Home] [Help] [Dependency Information]
Object Name: | DBA_APPLY |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Details about the apply process
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLY_NAME | VARCHAR2 | (128) | Yes | Name of the apply process |
QUEUE_NAME | VARCHAR2 | (128) | Yes | Name of the queue the apply process dequeues from |
QUEUE_OWNER | VARCHAR2 | (128) | Yes | Owner of the queue the apply process dequeues from |
APPLY_CAPTURED | VARCHAR2 | (3) | Yes, if applying captured messages; No, if applying enqueued messages | |
RULE_SET_NAME | VARCHAR2 | (128) | Rule set used by apply process for filtering | |
RULE_SET_OWNER | VARCHAR2 | (128) | Owner of the negative rule set | |
APPLY_USER | VARCHAR2 | (128) | Current user who is applying the messages | |
APPLY_DATABASE_LINK | VARCHAR2 | (128) | For remote objects, the database link pointing to the remote database | |
APPLY_TAG | RAW | (2000) | Tag associated with DDL and DML change records that will be applied | |
DDL_HANDLER | VARCHAR2 | (98) | Name of the user specified ddl handler | |
PRECOMMIT_HANDLER | VARCHAR2 | (98) | Name of the user specified precommit handler | |
MESSAGE_HANDLER | VARCHAR2 | (98) | User specified procedure to handle messages other than DDL and DML messages | |
STATUS | VARCHAR2 | (8) | Status of the apply process: DISABLED, ENABLED, ABORTED | |
MAX_APPLIED_MESSAGE_NUMBER | NUMBER | Maximum value of message that has been applied | ||
NEGATIVE_RULE_SET_NAME | VARCHAR2 | (128) | Negative rule set used by apply process for filtering | |
NEGATIVE_RULE_SET_OWNER | VARCHAR2 | (128) | ||
STATUS_CHANGE_TIME | DATE | The time that STATUS of the apply process was changed | ||
ERROR_NUMBER | NUMBER | Error number if the apply process was aborted | ||
ERROR_MESSAGE | VARCHAR2 | (4000) | Error message if the apply process was aborted | |
MESSAGE_DELIVERY_MODE | VARCHAR2 | (10) | ||
PURPOSE | VARCHAR2 | (19) | Purpose of this apply process |
Cut, paste (and edit) the following text to query this object:
SELECT APPLY_NAME
, QUEUE_NAME
, QUEUE_OWNER
, APPLY_CAPTURED
, RULE_SET_NAME
, RULE_SET_OWNER
, APPLY_USER
, APPLY_DATABASE_LINK
, APPLY_TAG
, DDL_HANDLER
, PRECOMMIT_HANDLER
, MESSAGE_HANDLER
, STATUS
, MAX_APPLIED_MESSAGE_NUMBER
, NEGATIVE_RULE_SET_NAME
, NEGATIVE_RULE_SET_OWNER
, STATUS_CHANGE_TIME
, ERROR_NUMBER
, ERROR_MESSAGE
, MESSAGE_DELIVERY_MODE
, PURPOSE
FROM SYS.DBA_APPLY;
|
|
|