Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

ALL_CAPTURE

ALL_CAPTURE displays information about the capture processes that enqueue the captured changes into queues accessible to the current user.

Related View

DBA_CAPTURE displays information about all 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 staging captured changes

QUEUE_OWNER

VARCHAR2(30)

NOT NULL

Owner of the queue used for staging captured changes

RULE_SET_NAME

VARCHAR2(30)

Name of the rule set used by the capture process for filtering

RULE_SET_OWNER

VARCHAR2(30)

Owner of the rule set

START_SCN

NUMBER

System change number (SCN) from which the capture process will start to capture changes

STATUS

VARCHAR2(8)

Status of the capture process:

  • DISABLED
  • ENABLED
  • ABORTED

CAPTURED_SCN

NUMBER

System change number (SCN) of the last captured message

APPLIED_SCN

NUMBER

System change number (SCN) of the most recent message dequeued by the relevant apply processes. All changes below this SCN have been dequeued by all apply processes that apply changes captured by this capture process.

See Also:

"DBA_CAPTURE"