Index Organised Table(IOT) DDL

Owned by Clive Otten (Unlicensed)
Jan 20, 2020
1 min read

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..