Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Truncate is the one DDL command that is replicated from Oracle to non Oracle databases. Truncate is replicated by default whether you have DDL replication turned on or not due to the MINE_TRUNCATE_WITHOUT_DDL parameter.Replication of DDL to non Oracle databases ignores partition clauses so DDL is affecting the whole table

The replicated TRUNCATE drops any Oracle-specific clauses, e.g. CASCADE.

Please set MINE_REWRITE_TRUNCATE_WITHOUT_DDL=NO to avoid this scenario.keep these extra options. In that case, the target must support them, too (e.g. CASCADE requires Oracle 12.1 or higher.)


Other statements

All other statements are not replicated. 

...