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

VIEW: SYS.CDB_XSTREAM_OUTBOUND

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

Details about the XStream outbound server in all containers

[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 (30)
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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_XSTREAM_OUTBOUND;

Dependencies

[top of page]

SYS.CDB_XSTREAM_OUTBOUND does not reference any database object

SYS.CDB_XSTREAM_OUTBOUND is referenced by following:

SchemaPUBLIC
SynonymCDB_XSTREAM_OUTBOUND