...
- alter table add supplemental logging: NOT replicated
- alter table drop supplemental logging: NOT replicated
- alter table add partition: replicated
- alter table drop (sub)partition: replicated
- alter table truncate (sub)partition: replicated
- alter table split (sub)partition: replicated
- alter table merge (sub)partition: replicated
- alter table exchange (sub)partition: replicated
- alter table set (sub)partition: replicated
- alter table coalesce (sub)partition: replicated
- alter table modify (sub)partition: replicated
- alter table rename "BIN..." : NOT replicated
- alter table rename/add/drop constraint: replicated
- alter table add: replicated
- alter table drop/rename column: replicated
- alter table rename: replicated
- alter table enable: replicated (2.7)
- alter table disable: replicated (2.7)
Note: Table Partition DDL is turned off by default because the target database may not support it or have the same partitions. To turn this on set _DDL_REPLICATE_PARTITIONS=YES
You need to ensure that you have explicitly named (sub)partition names to have the same object name both on source and target.
All others are NOT replicated.
Alter index
- alter index rename "BIN..." : NOT replicated
- alter index rename: replicated
- alter index (in-)visible: replicated
All others are NOT replicated.
...
All grants on objects are replicated. Systems grants are NOT replicated.
(see DDL_REPLICATE_GRANTS for more info on prerequisites needed for grants to be replicated)
Revoke
All grants on objects are replicated. Systems grants are NOT replicated.
...
All statements are replicated.1
Other statements
All other statements are not replicated.
***
1 Truncate
Truncate is the one DDL command that is replicated from Oracle to non Oracle databases. Truncate Truncate is replicated by default whether you have DDL replication turned on or not due to the the MINE_TRUNCATE_WITHOUT_DDL parameter.
Replication of DDL to non Oracle databases ignores partition clauses so DDL is affecting the whole table.
Please set MINE_TRUNCATE_WITHOUT_DDL=NO to avoid this scenario.
Other statements
All other statements are not replicated.
***