Changing Table structure from heap to IOT

From: Simon <simon.dobner.remove_this_at_crsrehab.gov.au>
Date: 17 Jul 2001 04:49:20 GMT
Message-ID: <Xns90E196C3FB96Asd@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 Mon Jul 16 2001 - 23:49:20 CDT