OGG Replicat fails with "WARNING OGG-00869 OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS" (Doc ID 1644272.1)

Last updated on DECEMBER 15, 2016

Applies to:

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

Symptoms

 The error would look like below

2014-03-28 21:27:55  WARNING OGG-00869  OCI Error ORA-26945: unsupported hint RESTRICT_ALL_REF_CONS (status = 26945), SQL <INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO <table name>

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