ALL_APPLY

ALL_APPLY displays information about the apply processes that dequeue from queues accessible to the current user.

Related View

DBA_APPLY displays information about all apply processes in the database.

Column	Datatype	NULL	Description
APPLY_NAME	VARCHAR2(30)	NOT NULL	Name of the apply process
QUEUE_NAME	VARCHAR2(30)	NOT NULL	Name of the queue the apply process dequeues from
QUEUE_OWNER	VARCHAR2(30)	NOT NULL	Owner of the queue the apply process dequeues from
APPLY_CAPTURED	VARCHAR2(3)		Indicates whether applying captured messages (YES) or enqueued messages (NO)
RULE_SET_NAME	VARCHAR2(30)		Rule set used by apply process for filtering
RULE_SET_OWNER	VARCHAR2(30)		Owner of the rule set
APPLY_USER	VARCHAR2(30)	NOT NULL	Current user who is applying the messages
APPLY_DATABASE_LINK	VARCHAR2(128)		Database link to which changes will be applied
APPLY_TAG	RAW(2000)		Tag associated with DDL and DML change records that will be applied
DDL_HANDLER	VARCHAR2(92)		Name of the user-specified ddl handler
MESSAGE_HANDLER	VARCHAR2(92)		User-specified procedure to handle messages other than DDL and DML messages
STATUS	VARCHAR2(8)		Status of the apply process: DISABLED ENABLED ABORTED

See Also: "DBA_APPLY"