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:
-
Oracle AI Database Utilities for more information about supplemental logging
-
“V$DATABASE” for information about supplemental logging in a CDB