6.24 DBA_SUPPLEMENTAL_LOGGING

DBA_SUPPLEMENTAL_LOGGING provides information about supplemental logging for a pluggable database (PDB) in a multitenant container database (CDB).

Column Datatype NULL Description

MINIMAL

VARCHAR2(3)

Identifies whether minimal supplemental logging is on (YES or NO)

PRIMARY_KEY

VARCHAR2(3)

Identifies whether primary key supplemental logging is on (YES or NO)

UNIQUE_INDEX

VARCHAR2(3)

Identifies whether unique column supplemental logging is on (YES or NO)

FOREIGN_KEY

VARCHAR2(3)

Identifies whether foreign key supplemental logging is on (YES or NO)

ALL_COLUMN

VARCHAR2(3)

Identifies whether all column supplemental logging is on (YES or NO)

PROCEDURAL

VARCHAR2(3)

Identifies whether supplemental logging for procedural replication is on (YES or NO)

SUBSET_REPFoot 1

VARCHAR2(3)

Indicates whether subset database replication is on (YES or NO)

Footnote 1 This column is available starting with Oracle Database release 19c, version 19.1.

See Also: