DBA_OGG_AUTO_CAPTURED_TABLES

DBA_OGG_AUTO_CAPTURED_TABLES describes all tables in the database that are enabled for Oracle GoldenGate automatic capture.

USER_OGG_AUTO_CAPTURED_TABLES describes the tables owned by the current user that are enabled for Oracle GoldenGate automatic capture. This view does not display the OWNER column.

Column Datatype NULL Description
OWNER VARCHAR2(128) NOT NULL Owner of the table
NAME VARCHAR2(128) NOT NULL Name of the table
ALLOW_NOVALIDATE_PK VARCHAR2(3)   Indicates whether a primary key constraint in NOVALIDATE mode can be used as a unique identifier for the table (YES) or not (NO)

See Also: “USER_OGG_AUTO_CAPTURED_TABLES”