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.

  1. Using GGSCI, connect to the DSN for the source and target databases.
    GGSCI> DBLOGIN SOURCEDB dsn USERIDALIAS alias
  2. Delete the Extract first.
    GGSCI> DELETE EXTRACT extname
  3. Unregister the Extract.
    GGSCI> UNREGISTER EXTRACT extname