CTAS and IOT

0 0

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

About Post Author

Alex Nuijten

alex.nuijten@amis.nl

Happy

0 0 %

Sad

0 0 %

Excited

0 0 %

Sleepy

0 0 %

Angry

0 0 %

Surprise

0 0 %

Related posts:

Oracle Designer – a tip for Generation of Forms – Enforce Post Generation SchemaSurf (Freeware) – Browser based tool to navigate the database Anydata and Collections Death of the End Date – How LAG and LEAD help fight redundancy Extract Domain Definitions from Oracle Designer for use in JHeadstart