The following DDL (Data Definition Language) is supported by Dbvisit Replicate. Note that DDL is only supported with Oracle to Oracle replication.1
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
- alter table disable: replicated
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
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.)
Create view
All statements are replicated. For views to be replicated the following conditions apply:
- DDL replication needs to be enabled
- The whole schema needs to be replicated. It is not possible to select individual views.
- All of the tables that are part of the view must be replicated.
Drop view
All statements are replicated.
Create cluster
All statements are replicated.
Drop cluster
All statements are replicated.
Create index
All statements are replicated.
Drop index
All statements are replicated.
Grant
All grants on objects are replicated. Systems grants are NOT replicated.
Revoke
All grants on objects are replicated. Systems grants are NOT replicated.
Truncate table
All statements are replicated.1
Other statements
All other statements are not replicated.
***
1 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.