Follow these instructions to remove supplemental logging and any Oracle GoldenGate CDC Cleanup objects from the source database in the Oracle GoldenGate capture configuration, and to remove the Replicat checkpoint table in the apply configuration. Specific steps and commands may not apply to your configuration.
On a Source System:
Log on as the system administrator or as a user with permission to issue Oracle GoldenGate commands and delete files and directories from the operating system.
Run ggsci.exe
from the Oracle GoldenGate directory.
Stop all Oracle GoldenGate processes if not already done.
.STOP ER *
Stop the Manager process.
..STOP MANAGER–
Issue the following command to log into the source database, see SOURCEDB.
DBLOGIN SOURCEDB data_source{, USERID user, PASSWORD password | USERIDALIAS alias}
Use this command to remove the Extract tables that you enabled for supplemental logging, see DELETE TRANDATA. You can use a wildcard to specify multiple table names.
DELETE TRANDATA owner.table
Remove any heartbeat table entries by running the DELETE HEARTBEATTABLE
command.
On a Target System: