GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

schematrandata

edited Apr 14, 2014 11:16AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered ✓

Hello,

Can somebody help understand the below said:

1. If a user (schema) is dropped and recreated (with the same name), then do we need to re-execute add schematrandata?

2. Under what circumstances would the key column (PK) not get logged? We are observing a strange behaviour where an update is failing with ora-1403 but the data on source & target is same and hence ora-1403 should not be encountered. On reading the trail file, it seems that the key column is not logged (and probably it is a noopupdate, but then we have allownoopupdates on the replicat side, so it should not matter).

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