CTAS and IOT

1

This was the second time I needed to look up how to create an Index Organized Table (IOT) with a Create Table As Select (CTAS).
So just a quick entry so I won’t forget…. or at least that I will know where to look.

create table [table_name]<br />( [col1] primary key<br />, [col2]<br />, [col3]<br />)<br />organization index<br />as<br />select [col1]<br />     , [col2]<br />     , [col3]<br />  from [table_name]<br />/<br /><table>
</table>

Documentation link:

http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96521/tables.htm

Share.

About Author

1 Comment