ALL_SYNC_CAPTURE displays information about the synchronous capture processes that store the captured changes in queues accessible to the current user.
DBA_SYNC_CAPTURE displays information about all synchronous 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 holding captured changes |
QUEUE_OWNER |
VARCHAR2(30) |
NOT NULL |
Owner of the queue used for holding captured changes |
RULE_SET_NAME |
VARCHAR2(30) |
Rule set used by the capture process | |
RULE_SET_OWNER |
VARCHAR2(30) |
Owner of the rule set | |
CAPTURE_USER |
VARCHAR2(30) |
Current user who is enqueueing captured messages |
See Also:
"DBA_SYNC_CAPTURE"