Solved

Compress All Operation on Index Organized tables

Posted on 2011-03-09
6
472 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.

Join & Write a Comment

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to take different types of Oracle backups using RMAN.

706 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now