Solved

Compress All Operation on Index Organized tables

Posted on 2011-03-09
6
480 Views
Last Modified: 2013-12-19
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.
0
Comment
Question by:mdasifs
6 Comments
 
LVL 15

Expert Comment

by:Franck Pachot
ID: 35093899
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
 
LVL 2

Expert Comment

by:swadhinray
ID: 35124979
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
 
LVL 2

Expert Comment

by:Cha1tu
ID: 35140219
can you post the error?
0
 

Accepted Solution

by:
mdasifs earned 0 total points
ID: 35245135
It seems we can't create IOT table with compress for all options ...
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to take different types of Oracle backups using RMAN.

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question