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_SYNC_CAPTURE

Object Details

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

Details about each sync capture process that stores the captured changes in a queue visible to the current user

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CAPTURE_NAME	VARCHAR2	(128)	Yes	Name of the capture process
QUEUE_NAME	VARCHAR2	(128)	Yes	Name of queue used for holding captured changes
QUEUE_OWNER	VARCHAR2	(128)	Yes	Owner of the queue used for holding captured changes
RULE_SET_NAME	VARCHAR2	(128)		Rule set used by capture process for filtering
RULE_SET_OWNER	VARCHAR2	(128)		Owner of the rule set
CAPTURE_USER	VARCHAR2	(128)		Current user who is enqueuing captured messages

Query Text

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


SELECT CAPTURE_NAME
,      QUEUE_NAME
,      QUEUE_OWNER
,      RULE_SET_NAME
,      RULE_SET_OWNER
,      CAPTURE_USER
FROM SYS.ALL_SYNC_CAPTURE;

Dependencies

[top of page]

SYS.ALL_SYNC_CAPTURE references the following:

SYS: ALL_QUEUES; ALL_RULE_SETS; DBA_SYNC_CAPTURE

SYS.ALL_SYNC_CAPTURE is referenced by following:

PUBLIC: ALL_SYNC_CAPTURE
SYS: _ALL_STREAMS_PROCESSES