Table Reorganization in Oracle 8i

[skdas]

Hi,

As far I know there are two ways for table reorganization.

1)Export with Compress, recreate the table with new parameters and import.

2)Create the table T2 with new parameters. Select from table T1 and put in T2. Rebuild the index, foreign key etc. then rename table T2 to T1.


Is there any other way or without down time or easier way than this..?

SKD

[mike9]

alter table move...
which is more or less the same as your second suggestion

[Ablakios]

1)Create Locally Managed tablespace

2)alter table X move tablespace Y;

but you have to rebuild indexes afterwards because after moving the table the rowid are different

[skdas]

In the move caluse, can we move to the existing table space. For example table emp is in tablespace T1. Through alter table move command, can we reorganize it, so that it will be reorganized in the same tablespace T1 or we need to write to table space different than T1.

[mike9]

have a look at:
http://download-east.oracle.com/docs...2a.htm#2054899
and you will see what you can or cant do with this command