Use CLEAR INSTANTIATION CSN on your target database to clear (reverse) the instantiation CSN manually. This command requires DBLOGIN where the user is the default Oracle GoldenGate schema.

Syntax

CLEAR INSTANTIATION CSN FOR [schema.]table FROM source-database-name

[schema.]table

The name of the table to clear the instantiation CSN on. If no schema is provided, the DBLOGIN user will be used.

source-database-name

The global name of the source database for which this is a target.

Example

CLEAR INSTANTIATION CSN FOR hr.employees FROM pdbeast.com