Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Reorganizing columns in an Index Organized Table
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_at_hln.com> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 08 2006 - 11:55:40 CDT