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

VIEW: SYS.DBA_APPLY

Object Details
Object Name: DBA_APPLY
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Details about the apply process

[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 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
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.DBA_APPLY;

Dependencies

[top of page]

SYS.DBA_APPLY references the following:

SchemaSYS
TableDUAL
TablePROPS$
TableSTREAMS$_CAPTURE_PROCESS
TableUSER$
TableXSTREAM$_SERVER
View_DBA_APPLY
SYS.DBA_APPLY is referenced by following:

SchemaPUBLIC
SynonymDBA_APPLY
SchemaSYS
ViewALL_APPLY
ViewDBA_APPLY_CHANGE_HANDLERS
ViewDBA_GOLDENGATE_INBOUND
ViewDBA_GOLDENGATE_RULES
ViewDBA_STREAMS_RULES
ViewDBA_STREAMS_STMTS
ViewDBA_STREAMS_STMT_HANDLERS
ViewDBA_XSTREAM_RULES
ViewDBA_XSTREAM_STMTS
ViewDBA_XSTREAM_STMT_HANDLERS
Package BodyDBMS_APPLY_ADM - show dependent code
Package BodyDBMS_APPLY_ADM_INTERNAL - show dependent code
Package BodyDBMS_APPLY_HANDLER_ADM - show dependent code
Package BodyDBMS_CAPTURE_ADM_INTERNAL - show dependent code
Package BodyDBMS_CAPTURE_SWITCH_INTERNAL - show dependent code
ProcedureDBMS_FEATURE_GOLDENGATE - show dependent code
ProcedureDBMS_FEATURE_STREAMS - show dependent code
ProcedureDBMS_FEATURE_XSTREAM_IN - show dependent code
ProcedureDBMS_FEATURE_XSTREAM_OUT - show dependent code
ProcedureDBMS_FEATURE_XSTREAM_STREAMS - show dependent code
Package BodyDBMS_LOGREP_UTIL - show dependent code
Package BodyDBMS_STREAMS_ADM_IVK - show dependent code
Package BodyDBMS_STREAMS_ADM_UTL - show dependent code
Package BodyDBMS_STREAMS_AUTO_INT - show dependent code
Package BodyDBMS_STREAMS_SM - show dependent code
Package BodyDBMS_XSTREAM_ADM_UTL - show dependent code
Package BodyDBMS_XSTREAM_UTL_IVK - show dependent code
View_DBA_GGXSTREAM_INBOUND
View_DBA_GGXSTREAM_OUTBOUND
View_DBA_STREAMS_COMPONENT
View_DBA_STREAMS_COMPONENT_EVENT
View_DBA_STREAMS_COMPONENT_LINK
View_DBA_STREAMS_COMPONENT_PROP