Keyword: CAPTURE
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| ALL_CAPTURE | Details about each capture process that stores the captured changes in a queue visible to the current user |
| ALL_CAPTURE_PARAMETERS | Details about parameters for each capture process that stores the captured changes in a queue visible to the current user |
| ALL_CAPTURE_PREPARED_DATABASE | Is the local database prepared for instantiation? |
| ALL_CAPTURE_PREPARED_SCHEMAS | All user schemas at the local database that are prepared for instantiation |
| ALL_CAPTURE_PREPARED_TABLES | All tables visible to the current user that are prepared for instantiation |
| DBA_CAPTURE | Details about the capture process |
| DBA_CAPTURE_PARAMETERS | All parameters for capture process |
| DBA_CAPTURE_PREPARED_DATABASE | Is the local database prepared for instantiation? |
| DBA_CAPTURE_PREPARED_SCHEMAS | All schemas at the local database that are prepared for instantiation |
| DBA_CAPTURE_PREPARED_TABLES | All tables prepared for instantiation |
| GV$STREAMS_CAPTURE | Synonym for GV_$STREAMS_CAPTURE |
| V$STREAMS_CAPTURE | Synonym for V_$STREAMS_CAPTURE |
Columns
| Column Name | Description |
|---|---|
| APPLY_CAPTURED (ALL_APPLY) | Yes, if applying captured messages; No, if applying enqueued messages |
| APPLY_CAPTURED (DBA_APPLY) | Yes, if applying captured messages; No, if applying enqueued messages |
| CAPTURE# (V$STREAMS_CAPTURE) | |
| CAPTURE# (GV$STREAMS_CAPTURE) | |
| CAPTURED_SCN (DBA_CAPTURE) | Everything up to this SCN has been captured |
| CAPTURE_MESSAGE_CREATE_TIME (V$STREAMS_CAPTURE) | |
| CAPTURE_MESSAGE_CREATE_TIME (GV$STREAMS_CAPTURE) | |
| CAPTURE_MESSAGE_NUMBER (V$STREAMS_CAPTURE) | |
| CAPTURE_MESSAGE_NUMBER (GV$STREAMS_CAPTURE) | |
| CAPTURE_NAME (ALL_CAPTURE) | Name of the capture process |
| CAPTURE_NAME (GV$STREAMS_CAPTURE) | |
| CAPTURE_NAME (DBA_CAPTURE) | Name of the capture process |
| CAPTURE_NAME (V$STREAMS_CAPTURE) | |
| CAPTURE_NAME (DBA_CAPTURE_PARAMETERS) | Name of the capture process |
| CAPTURE_NAME (ALL_CAPTURE_PARAMETERS) | Name of the capture process |
| CAPTURE_TIME (V$STREAMS_CAPTURE) | |
| CAPTURE_TIME (GV$STREAMS_CAPTURE) | |
| ELAPSED_CAPTURE_TIME (V$STREAMS_CAPTURE) | |
| ELAPSED_CAPTURE_TIME (GV$STREAMS_CAPTURE) | |
| TOTAL_MESSAGES_CAPTURED (V$STREAMS_CAPTURE) | |
| TOTAL_MESSAGES_CAPTURED (GV$STREAMS_CAPTURE) |