GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

DDL replication only - no DML /

Ok, so earlier I worked with Oracle support to get a GG Integrated extract working on a "normal" table (ie typical table, dml replication). as well as enabling DDL replication for that table, but restricting it to only DROP PARTITION.

we ended up with the following DDL command added:

DDL INCLUDE MAPPED INSTR 'DROP PARTITION'

This worked ok, however, as we continue to test/read/learn .. we're now leaning towards having this DDL in it's own seperate flow. (few reasons, but the biggest, is that our datamodel between the DBs is not 100% matched, so there lies some issues with having the DML and DDL in same flow with ASSUMETARGETDEFS).

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