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_CAPTURE

Object Details

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

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

[View Source]

Columns

Name	Datatype	Length	Comments
CAPTURE_NAME	VARCHAR2	(128)	Name of the capture process
QUEUE_NAME	VARCHAR2	(128)	Name of queue used for holding captured changes
QUEUE_OWNER	VARCHAR2	(128)	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)
START_SCN	NUMBER		The SCN from which capturing will be resumed
STATUS	VARCHAR2	(8)	Status of the capture process: DISABLED, ENABLED, ABORTED
CAPTURED_SCN	NUMBER		Everything up to this SCN has been captured
APPLIED_SCN	NUMBER		Everything up to this SCN has been applied
USE_DATABASE_LINK	VARCHAR2	(3)	Can use database_link from downstream to source database
FIRST_SCN	NUMBER		SCN from which the capture process can be restarted
SOURCE_DATABASE	VARCHAR2	(128)	Global name of the source database
SOURCE_DBID	NUMBER		DBID of the source database
SOURCE_RESETLOGS_SCN	NUMBER		Resetlogs_SCN of the source database
SOURCE_RESETLOGS_TIME	NUMBER		Resetlogs time of the source database
LOGMINER_ID	NUMBER		Session ID of LogMiner session associated with the capture process
NEGATIVE_RULE_SET_NAME	VARCHAR2	(128)	Negative rule set used by capture process for filtering
NEGATIVE_RULE_SET_OWNER	VARCHAR2	(128)	Owner of the negative rule set
MAX_CHECKPOINT_SCN	NUMBER		SCN at which the last check point was taken by the capture process
REQUIRED_CHECKPOINT_SCN	NUMBER		the safe SCN at which the meta-data for the capture process can be purged
LOGFILE_ASSIGNMENT	VARCHAR2	(8)	The logfile assignment type for the capture process
STATUS_CHANGE_TIME	DATE		The time that STATUS of the capture process was changed
ERROR_NUMBER	NUMBER		Error number if the capture process was aborted
ERROR_MESSAGE	VARCHAR2	(4000)	Error message if the capture process was aborted
VERSION	VARCHAR2	(64)	Version number of the capture process
CAPTURE_TYPE	VARCHAR2	(10)	Type of the capture process
LAST_ENQUEUED_SCN	NUMBER		SCN of the last message enqueued by the capture process
CHECKPOINT_RETENTION_TIME	NUMBER		Number of days checkpoints will be retained by the capture process
START_TIME	DATE
PURPOSE	VARCHAR2	(19)
SOURCE_ROOT_NAME	VARCHAR2	(128)	Global name of the source root database
CLIENT_NAME	VARCHAR2	(4000)	Name of the client process of the capture
CLIENT_STATUS	VARCHAR2	(8)	Status of the client process of the capture
OLDEST_SCN	NUMBER		Oldest SCN of the transaction currently being applied
FILTERED_SCN	NUMBER		SCN of the low watermark transaction processed

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
,      START_SCN
,      STATUS
,      CAPTURED_SCN
,      APPLIED_SCN
,      USE_DATABASE_LINK
,      FIRST_SCN
,      SOURCE_DATABASE
,      SOURCE_DBID
,      SOURCE_RESETLOGS_SCN
,      SOURCE_RESETLOGS_TIME
,      LOGMINER_ID
,      NEGATIVE_RULE_SET_NAME
,      NEGATIVE_RULE_SET_OWNER
,      MAX_CHECKPOINT_SCN
,      REQUIRED_CHECKPOINT_SCN
,      LOGFILE_ASSIGNMENT
,      STATUS_CHANGE_TIME
,      ERROR_NUMBER
,      ERROR_MESSAGE
,      VERSION
,      CAPTURE_TYPE
,      LAST_ENQUEUED_SCN
,      CHECKPOINT_RETENTION_TIME
,      START_TIME
,      PURPOSE
,      SOURCE_ROOT_NAME
,      CLIENT_NAME
,      CLIENT_STATUS
,      OLDEST_SCN
,      FILTERED_SCN
FROM SYS.ALL_CAPTURE;

Dependencies

[top of page]

SYS.ALL_CAPTURE references the following:

SYS: ALL_QUEUES; ALL_RULE_SETS; DBA_CAPTURE; DBMS_LOGREP_UTIL - show dependent code; GET_MAX_CHECKPOINT

SYS.ALL_CAPTURE is referenced by following:

PUBLIC: ALL_CAPTURE
SYS: ALL_CAPTURE_EXTRA_ATTRIBUTES; ALL_CAPTURE_PARAMETERS; ALL_COMPARISON_SCAN_SUMMARY; ALL_STREAMS_KEEP_COLUMNS; ALL_STREAMS_TRANSFORMATIONS; ALL_XSTREAM_TRANSFORMATIONS; DBMS_CAPTURE_ADM_IVK - show dependent code; DBMS_LOGREP_UTIL - show dependent code; DBMS_XSTREAM_UTL_IVK - show dependent code; _ALL_STREAMS_PROCESSES