Supported DDL

The following DDL (Data Definition Language) is supported by Dbvisit Replicate. Note that DDL is only supported with Oracle to Oracle replication.
The conditions are matched from top to bottom. First matched condition determines the result.
Result indicating "replicated" means that the DDL is further checked whether the respective schema or table is set to be replicated.

Create table

CREATE TABLE : replicated
CREATE TABLE as SELECT: replicated * (Tables containing LOB columns cannot be replicated with the CTAS command)

Alter table

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

All others are NOT replicated.

Drop table

Replicated. However, if is DROP TABLE … AS"BIN...", the rename part is removed. (This part is added internally by Oracle when the table is moved to recycle bin.)