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

[View Source]

Columns
Name Datatype Length Mandatory Comments
APPLY# NUMBER
Yes
APPLY_NAME VARCHAR2 (128) Yes
QUEUE_OID RAW (16) Yes
QUEUE_OWNER VARCHAR2 (128) Yes
QUEUE_NAME VARCHAR2 (128) Yes
STATUS NUMBER

FLAGS NUMBER

RULESET_OWNER VARCHAR2 (128)
RULESET_NAME VARCHAR2 (128)
MESSAGE_HANDLER VARCHAR2 (98)
DDL_HANDLER VARCHAR2 (98)
PRECOMMIT_HANDLER VARCHAR2 (98)
APPLY_USERID NUMBER

APPLY_DBLINK VARCHAR2 (128)
APPLY_TAG RAW (2000)
START_DATE DATE

END_DATE DATE

NEGATIVE_RULESET_OWNER VARCHAR2 (128)
NEGATIVE_RULESET_NAME VARCHAR2 (128)
SPARE1 NUMBER

SPARE2 NUMBER

SPARE3 NUMBER

STATUS_CHANGE_TIME DATE

ERROR_NUMBER NUMBER

ERROR_MESSAGE VARCHAR2 (4000)
UA_NOTIFICATION_HANDLER VARCHAR2 (98)
UA_RULESET_OWNER VARCHAR2 (128)
UA_RULESET_NAME VARCHAR2 (128)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APPLY#
,      APPLY_NAME
,      QUEUE_OID
,      QUEUE_OWNER
,      QUEUE_NAME
,      STATUS
,      FLAGS
,      RULESET_OWNER
,      RULESET_NAME
,      MESSAGE_HANDLER
,      DDL_HANDLER
,      PRECOMMIT_HANDLER
,      APPLY_USERID
,      APPLY_DBLINK
,      APPLY_TAG
,      START_DATE
,      END_DATE
,      NEGATIVE_RULESET_OWNER
,      NEGATIVE_RULESET_NAME
,      SPARE1
,      SPARE2
,      SPARE3
,      STATUS_CHANGE_TIME
,      ERROR_NUMBER
,      ERROR_MESSAGE
,      UA_NOTIFICATION_HANDLER
,      UA_RULESET_OWNER
,      UA_RULESET_NAME
FROM SYS._DBA_APPLY;

Dependencies

[top of page]

SYS._DBA_APPLY references the following:

SchemaSYS
TableSTREAMS$_APPLY_PROCESS
SYS._DBA_APPLY is referenced by following:

SchemaSYS
ViewDBA_APPLY
Package BodyDBMS_LOGREP_EXP - show dependent code
View_DBA_XSTREAM_OUTBOUND