Toad World® Forums

IOT Tables


#1

Hello,
I’m trying to create an Oracle Index Organized table entity but I don’t see how.

Then I tried doing a reverse engineer from an existing IOT table into TDM, the entity diagram was created but the SQL preview is showing that was not created as IOT table.

Any idea?

Thanks.


#2

Hello,

The only way to create Oracle Index organized table is to write e.g. the following text on the Physical Properties tab of a table (example):
ORGANIZATION INDEX
PCTTHRESHOLD 2 INCLUDING “COUNTRY_NAME”

To load it during RE, please select the "Load Organization Index Parameters for Tables"checkbox in the RE Wizard / Options page.

If you have more questions, please write us back. Thanks.

Regards,

Vladka + TDM Team


#3

Thanks. I tried that and worked.

What didn’t work is the reverse engineer method, that means creating the IOT entity from a source DB has not added ORGANIZATION INDEX as a physical table property.