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