GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

OGG replicat - strange "no data found"

edited Feb 10, 2014 9:09AM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered ✓

When replicat is applying complex delete transaction(from application SW) all the rows from different tables delete ok except one

This problem row has proper value in primary key column but replicat cannot see it

I cathed "erroneous" DML using SHOWSYNTAX option and when I execute it from sqlplus it does delete proper row!

This issue happens only when that "complex transaction" run

Could you suggest any idea how to find root of the issue?

Oracle 11.2.0.3

OGG 12.1.2.0.0

Thanks in advance

Vladimir

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center