RE: Reorganizing columns in an Index Organized Table

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Tue, 8 Aug 2006 12:59:20 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF270910FF5E@AABO-EXCHANGE02.bos.il.pqe>

You might try CTAS. That way, you'll be able to do nologging direct load.

--

Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning

Ours is the age that is proud of machines that can think and suspicious of men who try to. --H. Mumford Jones, 1892-1980

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nirmalya Das Sent: Tuesday, August 08, 2006 12:54 PM
To: oracle-l_at_freelists.org
Subject: Reorganizing columns in an Index Organized Table

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:

Create a new Index Organized Table
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-l Received on Tue Aug 08 2006 - 11:59:20 CDT