GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

urgent help -- REPERROR (DEFAULT, EXCEPTION) is discarding, not writing to exception tables.

edited May 15, 2014 12:00PM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

We are doing the bi-directional replicaiton, to handle the conflicts we are trying to write the all conflict data in exception tables. So that it can be dealt manually.

From oracle knowledge base, i came to know the REPERROR (DEFAULT, EXCEPTION) command will capture all ora errors raised in the conflict and write into exception table.

i tested by inserting the duplicate data manually, i can see the exception in exceptions table. But when we run the application which is high transactional,  simply  it's discarding the conflict data and  no exception written to exception tables.

when i  checked discard files, it has written below message format in discard file with ora no errors

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