7.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_REP

VARCHAR2(3)

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

See Also: