Solved

Compress All Operation on Index Organized tables

Posted on 2011-03-09
6
483 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

730 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