| Column ID | Column name | Data type | Length | Precision | NULL | Description |
|
| 1 | CAPTURE_NAME | VARCHAR2 | 30 | (null) | N | Name of the capture process |
| 2 | QUEUE_NAME | VARCHAR2 | 30 | (null) | N | Name of queue used for holding captured changes |
| 3 | QUEUE_OWNER | VARCHAR2 | 30 | (null) | N | Owner of the queue used for holding captured changes |
| 4 | RULE_SET_NAME | VARCHAR2 | 30 | (null) | Y | Rule set used by capture process for filtering |
| 5 | RULE_SET_OWNER | VARCHAR2 | 30 | (null) | Y | Owner of the rule set |
| 6 | CAPTURE_USER | VARCHAR2 | 30 | (null) | Y | NULL - oracleabc.com |
| 7 | START_SCN | NUMBER | 22 | (null) | Y | The SCN from which capturing will be resumed |
| 8 | STATUS | VARCHAR2 | 8 | (null) | Y | Status of the capture process: DISABLED, ENABLED, ABORTED |
| 9 | CAPTURED_SCN | NUMBER | 22 | (null) | Y | Everything up to this SCN has been captured |
| 10 | APPLIED_SCN | NUMBER | 22 | (null) | Y | Everything up to this SCN has been applied |
| 11 | USE_DATABASE_LINK | VARCHAR2 | 3 | (null) | Y | Can use database_link from downstream to source database |
| 12 | FIRST_SCN | NUMBER | 22 | (null) | Y | SCN from which the capture process can be restarted |
| 13 | SOURCE_DATABASE | VARCHAR2 | 128 | (null) | Y | Global name of the source database |
| 14 | SOURCE_DBID | NUMBER | 22 | (null) | Y | DBID of the source database |
| 15 | SOURCE_RESETLOGS_SCN | NUMBER | 22 | (null) | Y | Resetlogs_SCN of the source database |
| 16 | SOURCE_RESETLOGS_TIME | NUMBER | 22 | (null) | Y | Resetlogs time of the source database |
| 17 | LOGMINER_ID | NUMBER | 22 | (null) | Y | Session ID of LogMiner session associated with the capture process |
| 18 | NEGATIVE_RULE_SET_NAME | VARCHAR2 | 30 | (null) | Y | Negative rule set used by capture process for filtering |
| 19 | NEGATIVE_RULE_SET_OWNER | VARCHAR2 | 30 | (null) | Y | Owner of the negative rule set |
| 20 | MAX_CHECKPOINT_SCN | NUMBER | 22 | (null) | Y | SCN at which the last check point was taken by the capture process |
| 21 | REQUIRED_CHECKPOINT_SCN | NUMBER | 22 | (null) | Y | the safe SCN at which the meta-data for the capture process can be purged |
| 22 | LOGFILE_ASSIGNMENT | VARCHAR2 | 8 | (null) | Y | The logfile assignment type for the capture process |
| 23 | STATUS_CHANGE_TIME | DATE | 7 | (null) | Y | The time that STATUS of the capture process was changed |
| 24 | ERROR_NUMBER | NUMBER | 22 | (null) | Y | Error number if the capture process was aborted |
| 25 | ERROR_MESSAGE | VARCHAR2 | 4000 | (null) | Y | Error message if the capture process was aborted |
| 26 | VERSION | VARCHAR2 | 64 | (null) | Y | Version number of the capture process |
| 27 | CAPTURE_TYPE | VARCHAR2 | 10 | (null) | Y | Type of the capture process |
| 28 | LAST_ENQUEUED_SCN | NUMBER | 22 | (null) | Y | SCN of the last message enqueued by the capture process |
| 29 | CHECKPOINT_RETENTION_TIME | NUMBER | 22 | (null) | Y | Number of days checkpoints will be retained by the capture process |