Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Changing Table structure from heap to IOT

Re: Changing Table structure from heap to IOT

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Tue, 17 Jul 2001 05:05:50 GMT
Message-ID: <OIP47.360815$p33.7313052@news1.sttls1.wa.home.com>

You are going to have to do a ctas -> create table as select.

create table xxx as select * from yyy order by primaryKey; I forget the IOT syntax.
Jim
"Simon" <simon.dobner.remove_this_at_crsrehab.gov.au> wrote in message news:Xns90E196C3FB96Asd_at_152.91.10.119...
> Hi,
>
> I am having a little trouble working out the syntax for changing table
> structure from a heap table to an IOT. So far about the only way I have
> been able to work out to do it is either an export or rename table, then
> creating the table as an IOT and importing/inserting the data.
>
> A long time ago when I was an Ingres DBA I was able to change table
> structures on the fly, and I am expecting that Oracle (8.1.7) can do the
> same.
>
> If someone can help me out I would appreciate it ?
>
> Thanks
>
> SD
Received on Tue Jul 17 2001 - 00:05:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US