[Home] [Help] [Dependency Information]
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
Name | Datatype | Length | Mandatory | 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 |
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;
|
|
|