GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Query on Filtering

edited Apr 3, 2014 1:23PM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered ✓

Hi,

We are trying to filter some rows for a table but that results in replicat failing. The extract prm looks like the foll.:

table user.testtab, where (deptid=10);

table user.*;

But replicat fails with ora-1403. I think the above results in dml for testtab getting extracted twice (and hence getting applied twice on target). And probably the second dml fails on target side because it is referring to the new/changed value in the where clause. Is the understanding correct? If yes, is there a way out?

Thanks

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