Deleting an Extract
When removing an individual Extract from use against a source PostgreSQL database, or uninstalling Oracle GoldenGate, the Extract that was registered with a replication slot in the database must be unregistered in order to remove the replication slot entry, otherwise an ever-increasing database log size can occur.
Perform the following steps to remove and unregister the Extract when no longer needed.
-
Using GGSCI, connect to the DSN for the source and target databases.
GGSCI> DBLOGIN SOURCEDB dsn USERIDALIAS alias
-
Delete the Extract first.
GGSCI> DELETE EXTRACT extname
-
Unregister the Extract.
GGSCI> UNREGISTER EXTRACT extname