GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Streams replication (including DDL) of table with rename

edited Jan 16, 2018 5:00PM in GoldenGate, Streams and Distributed Database (MOSC) 10 commentsAnswered ✓

Attempting to setup a simple example of streams replication in 11.2.0.4 (RAC'ed on Exadata) while including DDL changes and renaming of table but I cannot seem to get around the "Missing MVDD" errors. I've tried several iterations of the script below, all to no avail. The data replicates without issue, just won't apply the DDL. I have searched for a solution but it has eluded me so far. I've attempted to "prepare" the table again on the source, no joy, re-set the instantiation SCN on the destination, no joy (the only thing this seems to accomplish is to remove the

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