DELETE SCHEMATRANDATA
Valid for Oracle.
Use DELETE SCHEMATRANDATA to remove the Oracle
schema-level supplemental logging that was added with the ADD
SCHEMATRANDATA command. Use the DBLOGIN command to
establish a database connection before using this command. The user that is
specified with this command must have the privilege to remove supplemental log
groups.
By default, this command attempts to remove the supplemental logging of
the key columns that are used by Oracle GoldenGate (can be the primary key, a unique
key, KEYCOLS columns, or all columns) and also the scheduling
columns. The scheduling columns are the primary key, all of the unique keys, and all
of the foreign keys. To delete the logging of the Oracle GoldenGate key columns, but
not the scheduling columns, include the NOSCHEDULINGCOLS option
with DELETE SCHEMATRANDATA. If ADD SCHEMATRANDATA
was issued with the ALLCOLS option, use DELETE
SCHEMATRANDATA with the ALLCOLS option to remove the
supplemental logging of all of the columns, including the Oracle GoldenGate key
columns.
Syntax
DELETE SCHEMATRANDATA schema [NOSCHEDULINGCOLS | ALLCOLS]-
schema -
The schema for which you want supplemental logging to be removed. Do not use a wildcard. If the source is an Oracle multitenant container database, make certain to log into the pluggable database that contains the schema for which you want to remove the logging.
-
NOSCHEDULINGCOLS -
Prevents the command from removing the supplemental logging of the scheduling columns of the tables in the specified schema. The scheduling columns are the primary key, all of the unique keys, and all of the foreign keys of a table.
-
ALLCOLS -
Removes the supplemental logging of all of the columns of the tables in the specified schema.
Parent topic: Admin Client Command Line Interface Commands