ORA-1000 Raised In 12c Database with Integrated Replicat (Doc ID 2216971.1)

Last updated on JANUARY 12, 2017

Applies to:

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

Symptoms

After upgrading to 12.1 database, you may notice ORA-1000 errors in your alert.log while using Integrated Replicat. Issue is seen when we have Materialized view created on the base tables being replicated by OGG. MV created here was REFRESH on COMMIT.  Issue will not reproduce on Classic Replicat.

 

Cause

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