Add Supplemental Log Groups Automatically

Use the DDLOPTIONS parameter with the ADDTRANDATA option for performing tasks described in this topic.

You can perform the following tasks using the DDLOPTIONS:

  • Enable Oracle's supplemental logging automatically for new tables created with a CREATE TABLE.

  • Update Oracle's supplemental logging for tables affected by an ALTER TABLE to add or drop columns.

  • Update Oracle's supplemental logging for tables that are renamed.

  • Update Oracle's supplemental logging for tables where unique or primary keys are added or dropped.

To use DDLOPTIONS ADDSCHEMATRANDATA, the ADD SCHEMATRANDATA command must be issued on the Admin Client to enable schema-level supplemental logging.

DDLOPTIONS ADDTRANDATA is not supported for multitenant container databases, see Configuring Logging Properties for more information.