CTAS and IOT

Alex Nuijten 1
0 0
Read Time:23 Second

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

Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

One thought on “CTAS and IOT

Comments are closed.

Next Post

R12 AD utilities: One step forward, two steps back?

After having completed my first installation of E-Business Suite Release 12, I decided to take a look on Metalink whether there were some critical updates to EBS Release 12. My special interest was in the Applications Technology Family. I found out there was a number of patches to be applied. […]
%d bloggers like this: