Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Replicat abends - Verifying Deferrable Constraints

DBA112Jul 6 2018 — edited Jul 9 2018

Dear Golden Gate Experts,

We are using OGG version - 12.2.0.1 to migrate an Oracle DB from Solaris to Linux. DB version - 11.2.0.4 and we are using Integrated extract/replicat.

As part of the migration we set up schemas to replicate. The extract and pump processes are running fine, but replicat abends  with - "OGG-00418  :Error encountered when verifying deferrable constraint"

However, the only constraints that are in "DEFERRED" state are few RI constraints in the "EXFSYS" schema on source and target and this schema is not set up for replication.

Can you share your thoughts on why Replicat is abending and what deferrable constraints is it trying to verify ?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2018
Added on Jul 6 2018
4 comments
1,756 views