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_XSTREAM_INBOUND

Object Details

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

Details about the XStream inbound server visible to user

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SERVER_NAME	VARCHAR2	(128)	Yes	Name of the inbound server
QUEUE_OWNER	VARCHAR2	(128)	Yes	Owner of the queue associated with the inbound server
QUEUE_NAME	VARCHAR2	(128)	Yes	Name of the queue associated with the inbound server
APPLY_USER	VARCHAR2	(128)		Name of the user who is applying the messages
USER_COMMENT	VARCHAR2	(4000)		User comment
CREATE_DATE	TIMESTAMP(6)	(11)		Date when inbound server was created
STATUS	VARCHAR2	(8)		Status of the apply process: DISABLED, ABORTED, ATTACHED, DETACHED
COMMITTED_DATA_ONLY	VARCHAR2	(3)		Is inbound server receiving committed data only?

Query Text

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


SELECT SERVER_NAME
,      QUEUE_OWNER
,      QUEUE_NAME
,      APPLY_USER
,      USER_COMMENT
,      CREATE_DATE
,      STATUS
,      COMMITTED_DATA_ONLY
FROM SYS.ALL_XSTREAM_INBOUND;

Dependencies

[top of page]

SYS.ALL_XSTREAM_INBOUND references the following:

SYS: ALL_APPLY; DBA_XSTREAM_INBOUND

SYS.ALL_XSTREAM_INBOUND is referenced by following:

PUBLIC: ALL_XSTREAM_INBOUND