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


VIEW: SYS.ALL_XSTREAM_OUTBOUND

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

Details about the XStream outbound server visible to user

[View Source]

Columns
Name Datatype Length Mandatory Comments
SERVER_NAME VARCHAR2 (128) Yes Name of the outbound server
CONNECT_USER VARCHAR2 (30)
Name of the user who can process the outbound LCR stream
CAPTURE_NAME VARCHAR2 (128)
Name of the XStream capture process
SOURCE_DATABASE VARCHAR2 (128)
Database where the transaction originated
CAPTURE_USER VARCHAR2 (128)
Current user who is enqueuing captured messages
QUEUE_OWNER VARCHAR2 (128) Yes Owner of the queue associated with the outbound server
QUEUE_NAME VARCHAR2 (128) Yes Name of the queue associated with the outbound server
USER_COMMENT VARCHAR2 (4000)
User comment
CREATE_DATE TIMESTAMP(6) (11)
Date when outbound server was created
STATUS VARCHAR2 (8)
Status of the apply process: DISABLED, ABORTED, DETACHED, ATTACHED
COMMITTED_DATA_ONLY VARCHAR2 (3)
Is outbound server sending committed data only?
START_SCN NUMBER

Start SCN of the associated co-located capture process
START_TIME DATE

Start time of the associated co-located capture process
SOURCE_ROOT_NAME VARCHAR2 (128)
Root database where all transactions originated
Query Text

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


SELECT SERVER_NAME
,      CONNECT_USER
,      CAPTURE_NAME
,      SOURCE_DATABASE
,      CAPTURE_USER
,      QUEUE_OWNER
,      QUEUE_NAME
,      USER_COMMENT
,      CREATE_DATE
,      STATUS
,      COMMITTED_DATA_ONLY
,      START_SCN
,      START_TIME
,      SOURCE_ROOT_NAME
FROM SYS.ALL_XSTREAM_OUTBOUND;

Dependencies

[top of page]

SYS.ALL_XSTREAM_OUTBOUND references the following:

SchemaSYS
ViewALL_APPLY
ViewDBA_XSTREAM_OUTBOUND
PL/SQL PackageDBMS_LOGREP_UTIL - show dependent code
FunctionGET_MAX_CHECKPOINT
SYS.ALL_XSTREAM_OUTBOUND is referenced by following:

SchemaPUBLIC
SynonymALL_XSTREAM_OUTBOUND
SchemaSYS
Package BodyDBMS_CAPTURE_ADM_IVK - show dependent code
Package BodyDBMS_XSTREAM_UTL_IVK - show dependent code