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..?
alter table move...
which is more or less the same as your second suggestion
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
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.
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.
have a look at:
and you will see what you can or cant do with this command
Click Here to Expand Forum to Full Width