Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Changing Table structure from heap to IOT
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