GoldenGate Initial Load With SCN Abending With Invalid option for SQLPREDICATE (Doc ID 2133450.1)

Last updated on MAY 29, 2016

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Goal

I tried to run goldengate initial load with SCN to reduce the down time for database migration since this is from Oracle to Mysql so data pump is not a option. initial load failed with error:


2016-04-26 14:16:39 ERROR OGG-00210 Invalid option for SQLPREDICATE.
not sure if this is a gg version or something I did not set correctly.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms