We're here to help!

Index Organised Table(IOT) DDL

Follow
Problem Description

Does IOT(Index Organised Table) DDL replicate?  ie. if we have DDL enabled in Replicate and create an IOT on source whether this should also be expected to be created as an IOT on target

Solution
If you run CREATE TABLE IOT_table(col1, col2, …) organization index - then we will replicate the whole DDL and you get it all. 
However, if you run CREATE TABLE AS SELECT(CTAS), then we conjure up new DDL for it (a non-CTAS one), and that’s when you don’t get any of the indexes, etc..
 
Have more questions? Submit a request

Comments