Re: Reorganizing columns in an Index Organized Table

  • From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
  • To: nirmalya@xxxxxxx
  • Date: Tue, 8 Aug 2006 18:55:40 +0200

You could try using dbms_redefinition , it might support IOT's but I'm not
sure off hand, you'll have to check the docs

Stefan

On 8/8/06, Nirmalya Das <nirmalya@xxxxxxx> wrote: 

Hi All,

I am in the process of reorganizing an IOT columns so the active columns
(which
has been added later) can be grouped together and non active (future
enhancement) columns can be kept in the overflow section of the IOT.

Environment:

RDBMS: Oracle 10.1.0.4 Standard Edition
OS : RHEL ES 4

This is what I am doing:

1. Create a new Index Organized Table
2. Insert into <NEWIOT> Select (column1...column80) from the <OLDIOT>
3. Drop table <OLDIOT>
4. Rename table <NEWIOT> to <OLDIOT>

Is there a better procedure that anyone can suggest?

TIA,

Nirmalya
--
//www.freelists.org/webpage/oracle-l



Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2006