eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.ALL_APPLY

Object Details

Object Name:	ALL_APPLY
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Details about each apply process that dequeues from the queue visible to the current user

[View Source]

Columns

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 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)		Owner of the negative rule set
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

Query Text

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.ALL_APPLY;

Dependencies

[top of page]

SYS.ALL_APPLY references the following:

SYS: ALL_QUEUES; ALL_RULE_SETS; DBA_APPLY

SYS.ALL_APPLY is referenced by following:

PUBLIC: ALL_APPLY
SYS: ALL_APPLY_CHANGE_HANDLERS; ALL_APPLY_DML_CONF_HANDLERS; ALL_APPLY_HANDLE_COLLISIONS; ALL_APPLY_INSTANTIATED_GLOBAL; ALL_APPLY_INSTANTIATED_OBJECTS; ALL_APPLY_INSTANTIATED_SCHEMAS; ALL_APPLY_PARAMETERS; ALL_APPLY_PROGRESS; ALL_APPLY_REPERROR_HANDLERS; ALL_APPLY_SPILL_TXN; ALL_COMPARISON_SCAN_SUMMARY; ALL_GG_INBOUND_PROGRESS; ALL_GOLDENGATE_INBOUND; ALL_STREAMS_KEEP_COLUMNS; ALL_STREAMS_TRANSFORMATIONS; ALL_XSTREAM_INBOUND; ALL_XSTREAM_INBOUND_PROGRESS; ALL_XSTREAM_OUTBOUND; ALL_XSTREAM_OUTBOUND_PROGRESS; ALL_XSTREAM_OUT_SUPPORT_MODE; ALL_XSTREAM_TRANSFORMATIONS; DBMS_LOGREP_UTIL - show dependent code; _ALL_STREAMS_PROCESSES