ALL_SYNC_CAPTURE

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(128) NOT NULL Name of the capture process
QUEUE_NAME VARCHAR2(128) NOT NULL Name of the queue used for holding captured changes
QUEUE_OWNER VARCHAR2(128) NOT NULL Owner of the queue used for holding captured changes
RULE_SET_NAME VARCHAR2(128)   Rule set used by the capture process
RULE_SET_OWNER VARCHAR2(128)   Owner of the rule set
CAPTURE_USER VARCHAR2(128)   Current user who is enqueuing captured messages

See Also: “DBA_SYNC_CAPTURE”