Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 19596 invoked from network); 8 Aug 2006 11:59:48 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 8 Aug 2006 11:59:48 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C619A3BDD9D; Tue, 8 Aug 2006 12:59:32 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 31769-07; Tue, 8 Aug 2006 12:59:32 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 453673BDAEC; Tue, 8 Aug 2006 12:59:32 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 08 Aug 2006 12:58:41 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 67B543BDA14 for ; Tue, 8 Aug 2006 12:58:41 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 31607-01 for ; Tue, 8 Aug 2006 12:58:41 -0400 (EDT) Received: from mx02.il.proquest.com (mx02.il.proquest.com [192.195.245.52]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3ABCB3BDA99 for ; Tue, 8 Aug 2006 12:58:41 -0400 (EDT) X-ASG-Debug-ID: 1155056331-18412-143-0 X-Barracuda-URL: http://spam.il.proquest.com:8000/cgi-bin/mark.cgi X-ASG-Whitelist: Client Received: from AABO-EXCHANGE04.bos.il.pqe (aabo-exchange04.bos.il.pqe [172.24.3.208]) by mx02.il.proquest.com (Spam Firewall) with ESMTP id D848D2EF1A; Tue, 8 Aug 2006 12:58:51 -0400 (EDT) Received: from AABO-EXCHANGE02.bos.il.pqe ([172.24.3.200]) by AABO-EXCHANGE04.bos.il.pqe with Microsoft SMTPSVC(6.0.3790.1830); Tue, 8 Aug 2006 12:58:48 -0400 x-mimeole: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-ASG-Orig-Subj: RE: Reorganizing columns in an Index Organized Table Subject: RE: Reorganizing columns in an Index Organized Table Date: Tue, 8 Aug 2006 12:59:20 -0400 Message-ID: In-Reply-To: <20060808095355.n2ekaowk8sk04oko@www.hln.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Reorganizing columns in an Index Organized Table From: "Bobak, Mark" To: , X-OriginalArrivalTime: 08 Aug 2006 16:58:48.0746 (UTC) FILETIME=[EAF2E8A0:01C6BB0B] X-Barracuda-Spam-Score: 0.00 X-Barracuda-Spam-Status: No, SCORE=0.00 using global scores of TAG_LEVEL=3.5 QUARANTINE_LEVEL=5.0 KILL_LEVEL00.0 X-archive-position: 37892 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Mark.Bobak@il.proquest.com Precedence: normal Reply-to: Mark.Bobak@il.proquest.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Nirmalya Das Sent: Tuesday, August 08, 2006 12:54 PM To: oracle-l@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: 1. Create a new Index Organized Table 2. Insert into Select (column1...column80) from the 3. Drop table 4. Rename table to 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