Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 19164 invoked from network); 8 Aug 2006 11:56:57 -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:56:52 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 26F8A3BE1CE;
 Tue,  8 Aug 2006 12:56:17 -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 31076-05; Tue, 8 Aug 2006 12:56:17 -0400 (EDT)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9ABC63BE1CD;
 Tue,  8 Aug 2006 12:56:16 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 08 Aug 2006 12:55:26 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C03853BDA14
 for <oracle-l@freelists.org>; Tue,  8 Aug 2006 12:55:26 -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 30546-06 for <oracle-l@freelists.org>;
 Tue, 8 Aug 2006 12:55:26 -0400 (EDT)
Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.190])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 184643BDB50
 for <oracle-l@freelists.org>; Tue,  8 Aug 2006 12:55:25 -0400 (EDT)
Received: by nf-out-0910.google.com with SMTP id c29so288794nfb
        for <oracle-l@freelists.org>; Tue, 08 Aug 2006 09:55:40 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
        b=J6/MjHLUaPUXXp9rKGSInBRw3AgqkmFhNtYJkizGd+b7vNGb/5jG9mn6S4yJIaQYf0Vtme5AJKiHSd20WNN0EguyufkrDZJEbdbZjXuq1K0BQHZ70mrpquMFoQCtpuk7HL/gU6jQlbfaUejgCilKjMnuJuzwoVMGgReMHu8DR7Y=
Received: by 10.78.140.17 with SMTP id n17mr2850168hud;
        Tue, 08 Aug 2006 09:55:40 -0700 (PDT)
Received: by 10.78.146.16 with HTTP; Tue, 8 Aug 2006 09:55:40 -0700 (PDT)
Message-ID: <486b2b610608080955q1f897141wa8f127a08c9b34d7@mail.gmail.com>
Date: Tue, 8 Aug 2006 18:55:40 +0200
From: "Stefan Knecht" <knecht.stefan@gmail.com>
To: nirmalya@hln.com
Subject: Re: Reorganizing columns in an Index Organized Table
Cc: oracle-l <oracle-l@freelists.org>
In-Reply-To: <20060808095355.n2ekaowk8sk04oko@www.hln.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_14031_10753640.1155056140030"
References: <20060808095355.n2ekaowk8sk04oko@www.hln.com>
X-archive-position: 37891
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: knecht.stefan@gmail.com
Precedence: normal
Reply-to: knecht.stefan@gmail.com
X-list: oracle-l
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net
------=_Part_14031_10753640.1155056140030
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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@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
>
>
>

------=_Part_14031_10753640.1155056140030
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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<br><br>Stefan<br><br><div><span class="gmail_quote">On 8/8/06, <b class="gmail_sendername">Nirmalya Das
</b> &lt;<a href="mailto:nirmalya@hln.com">nirmalya@hln.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi All,<br>
<br>I am in the process of reorganizing an IOT columns so the active columns (which<br>has been added later) can be grouped together and non active (future<br>enhancement) columns can be kept in the overflow section of the IOT.
<br><br>Environment:<br><br>RDBMS: Oracle <a href="http://10.1.0.4">10.1.0.4</a> Standard Edition<br>OS : RHEL ES 4<br><br>This is what I am doing:<br><br>1. Create a new Index Organized Table<br>2. Insert into &lt;NEWIOT&gt; Select (column1...column80) from the &lt;OLDIOT&gt;
<br>3. Drop table &lt;OLDIOT&gt;<br>4. Rename table &lt;NEWIOT&gt; to &lt;OLDIOT&gt;<br><br>Is there a better procedure that anyone can suggest?<br><br>TIA,<br><br>Nirmalya<br>--<br><a href="http://www.freelists.org/webpage/oracle-l">
http://www.freelists.org/webpage/oracle-l</a><br><br><br></blockquote></div><br>

------=_Part_14031_10753640.1155056140030--
--
http://www.freelists.org/webpage/oracle-l