4.3 CLEAR INSTANTIATION CSN

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 DBS1.US.COMPANY.COM