ALL_CAPTURE

ALL_CAPTURE displays information about the capture processes that enqueue the captured changes into queues accessible to the current user.

Related View

DBA_CAPTURE displays information about all capture processes in the database.

Column	Datatype	NULL	Description
`CAPTURE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the capture process
`QUEUE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the queue used for staging captured changes
`QUEUE_OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the queue used for staging captured changes
`RULE_SET_NAME`	`VARCHAR2(30)`		Name of the positive rule set used by the capture process for filtering
`RULE_SET_OWNER`	`VARCHAR2(30)`		Owner of the positive rule set
`CAPTURE_USER`	`VARCHAR2(30)`		Current user who is enqueuing captured messages
`START_SCN`	`NUMBER`		System change number (SCN) from which the capture process will start to capture changes
`STATUS`	`VARCHAR2(8)`		Status of the capture process: `DISABLED` `ENABLED` `ABORTED`
`CAPTURED_SCN`	`NUMBER`		System change number (SCN) of the last redo log record scanned
`APPLIED_SCN`	`NUMBER`		System change number (SCN) of the most recent message dequeued by the relevant apply processes. All changes below this SCN have been dequeued by all apply processes that apply changes captured by this capture process.
`USE_DATABASE_LINK`	`VARCHAR2(3)`		Indicates whether the source database name is used as the database link to connect to the source database from the downstream database (`YES`) or not (`NO`). If the capture process was created at the source database, then this column will be NULL.
`FIRST_SCN`	`NUMBER`		System change number (SCN) from which the capture process can be restarted
`SOURCE_DATABASE`	`VARCHAR2(128)`		Global name of the source database
`SOURCE_DBID`	`NUMBER`		Database ID of the source database
`SOURCE_RESETLOGS_SCN`	`NUMBER`		Resetlogs system change number (SCN) of the source database
`SOURCE_RESETLOGS_TIME`	`NUMBER`		Resetlogs time of the source database
`LOGMINER_ID`	`NUMBER`		Session ID of the LogMiner session associated with the capture process
`NEGATIVE_RULE_SET_NAME`	`VARCHAR2(30)`		Name of the negative rule set used by the capture process for filtering
`NEGATIVE_RULE_SET_OWNER`	`VARCHAR2(30)`		Owner of the negative rule set used by the capture process for filtering
`MAX_CHECKPOINT_SCN`	`NUMBER`		System change number (SCN) at which the last checkpoint was taken by the capture process
`REQUIRED_CHECKPOINT_SCN`	`NUMBER`		Lowest checkpoint SCN for which the capture process requires redo information
`LOGFILE_ASSIGNMENT`	`VARCHAR2(8)`		Logfile assignment type for the capture process: `IMPLICIT` `EXPLICIT`
`STATUS_CHANGE_TIME`	`DATE`		Time that the `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: `DOWNSTREAM` `LOCAL`
`LAST_ENQUEUED_SCN`	`NUMBER`		Last enqueued system change number (SCN)
`CHECKPOINT_RETENTION_TIME`	`NUMBER`		Checkpoint retention time Note: When the checkpoint retention time for a capture process is set to `INFINITE`, then the value displayed in this column is 4294967295.
`START_TIME`^Foot 1	`TIMESTAMP(6)`		Time from which the capture process will start to capture changes
`PURPOSE`^Footref 1	`VARCHAR2(19)`		Purpose of the capture process: `Streams` - A capture process in an Oracle Streams configuration `XStream` `Streams` - A capture process in an Oracle Streams configuration with XStream capabilities enabled by the `DBMS_XSTREAM_ADM`.`ENABLE_GG_XSTREAM_FOR_STREAMS` procedure `XStream` `Out` - A capture process in an XStream Out configuration `AUDIT` `VAULT` - A capture process in an audit vault configuration `CHANGE` `DATA` `CAPTURE` - A capture process in a change data capture configuration

^Footnote 1This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).