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).