GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Ora 1008 on CLOB tables

edited Jun 26, 2018 9:43AM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered ✓

Hi,

I am facing a peculiar issue on the CLOB tables. While replicating data on CLOB tables the replicat abended with ORA 1008, but we directed those error to exception table. The actual Source data will replicate only when it satisfies col A='D' but the default data inserted in Source would be COL A='A' and then it will be updated to COL A='D' at 1:02:03 pm.The twist occurs when it replicates to target , the data goes to exception table with ORA:1008 at 1:02:05pm, But we can also see the same data available in the Target table with the time gap of few secs.

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