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.