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.
By default, the ALTER TABLE
that adds the supplemental
logging is not replicated to the target unless the GETREPLICATES
parameter is in use.
DDLOPTIONS ADDTRANDATA
is not supported for multitenant
container databases, see Configure Logging Properties for more information.