CTAS and IOT

1
Share this on .. Tweet about this on TwitterShare on LinkedIn0Share on Facebook0Share on Google+0Email this to someoneShare on Tumblr0Buffer this page

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]( [col1] primary key
, [col2]
, [col3]
)
organization index
as
select [col1]
, [col2]
, [col3]
from [table_name]/

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

Share this on .. Tweet about this on TwitterShare on LinkedIn0Share on Facebook0Share on Google+0Email this to someoneShare on Tumblr0Buffer this page

About Author

1 Comment