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._DBA_XSTREAM_OUTBOUND

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
OUTBOUND_SERVER	VARCHAR2	(128)	Yes
COMMITTED_DATA_ONLY	VARCHAR2	(3)
CAPTURE_NAME	VARCHAR2	(128)
CAPTURE_STATUS	VARCHAR2	(8)
FIRST_SCN	NUMBER
CAPTURED_SCN	NUMBER
LAST_ENQUEUED_SCN	NUMBER
SOURCE_DATABASE	VARCHAR2	(128)
CAPTURE_RULESET_OWNER	VARCHAR2	(128)
CAPTURE_RULESET_NAME	VARCHAR2	(128)
CAPTURE_NEG_RULESET_OWNER	VARCHAR2	(128)
CAPTURE_NEG_RULESET_NAME	VARCHAR2	(128)
CAPTURE_USER	VARCHAR2	(128)
CAPTURE_QUEUE_OWNER	VARCHAR2	(128)
CAPTURE_QUEUE_NAME	VARCHAR2	(128)
OUTBOUND_SERVER_STATUS	VARCHAR2	(8)
CONNECT_USER	VARCHAR2	(30)
OUTBOUND_RULESET_OWNER	VARCHAR2	(128)
OUTBOUND_RULESET_NAME	VARCHAR2	(128)
OUTBOUND_NEG_RULESET_OWNER	VARCHAR2	(128)
OUTBOUND_NEG_RULESET_NAME	VARCHAR2	(128)
OLDEST_SCN	NUMBER
APPLIED_SCN	NUMBER
SPARE1	NUMBER
SPARE2	NUMBER
SPARE3	NUMBER

Query Text

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


SELECT OUTBOUND_SERVER
,      COMMITTED_DATA_ONLY
,      CAPTURE_NAME
,      CAPTURE_STATUS
,      FIRST_SCN
,      CAPTURED_SCN
,      LAST_ENQUEUED_SCN
,      SOURCE_DATABASE
,      CAPTURE_RULESET_OWNER
,      CAPTURE_RULESET_NAME
,      CAPTURE_NEG_RULESET_OWNER
,      CAPTURE_NEG_RULESET_NAME
,      CAPTURE_USER
,      CAPTURE_QUEUE_OWNER
,      CAPTURE_QUEUE_NAME
,      OUTBOUND_SERVER_STATUS
,      CONNECT_USER
,      OUTBOUND_RULESET_OWNER
,      OUTBOUND_RULESET_NAME
,      OUTBOUND_NEG_RULESET_OWNER
,      OUTBOUND_NEG_RULESET_NAME
,      OLDEST_SCN
,      APPLIED_SCN
,      SPARE1
,      SPARE2
,      SPARE3
FROM SYS._DBA_XSTREAM_OUTBOUND;

Dependencies

[top of page]

SYS._DBA_XSTREAM_OUTBOUND references the following:

SYS: DBA_CAPTURE; DBA_XSTREAM_OUTBOUND; DBMS_LOGREP_UTIL - show dependent code; GET_MAX_CHECKPOINT; XSTREAM$_SERVER_CONNECTION; _DBA_APPLY; _DBA_CAPTURE

SYS._DBA_XSTREAM_OUTBOUND is not referenced by any database object