?
Solved

Compress All Operation on Index Organized tables

Posted on 2011-03-09
6
Medium Priority
?
491 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

762 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