mdasifs
asked on
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.
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.
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.
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.
can you post the error?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.