Compress All Operation on Index Organized tables

Hi,

I am working on Oracle 10g DB.

Can we create Index-Organized table with compress all operations?

I tried, it gave me error. But if I don't use All operations table get created. And if I view the table script is it like

Create table sample as
(
...
...
primary key(......))
organization index
compress 5

What is this compress 5 mean? What are the merits and demerits of IOT table without compress
and IOT table with compress?

Thanks in Advance.
mdasifsAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
mdasifsConnect With a Mentor Author Commented:
It seems we can't create IOT table with compress for all options ...
0
 
Franck PachotCommented:
Hi,
IOT are indexes. It uses index compression: the 5 first columns of the index will not be repeated for each index entry.
You will have an error if the index has less than 6 columns.
Regards,
Franck.
0
 
swadhinrayCommented:
how many columns do you have in your table?

If you table that you are creating is having 4 columns then try to use  5 and if it has  more then use as  franckpachot: suggested.
0
 
Cha1tuCommented:
can you post the error?
0
All Courses

From novice to tech pro — start learning today.