Enabling Supplemental Logging in a CDB

In a CDB, the syntax for enabling and disabling database-wide supplemental logging is the same as in a non-CDB database:

ALTER DATABASE [ADD|DROP] SUPPLEMENTAL LOG DATA ...

However, in a CDB, minimal supplemental logging affects the entire CDB. All other levels of supplemental logging can be turned on and off at the PDB level. You must be connected to the PDB to issue the commands.

Supplemental logging operations started with CREATE TABLE and ALTER TABLE statements can be executed from either the root database or a PDB and affect only the table to which they are applied.