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.

Related View

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 enqueuing captured messages