If you are using 8i then use this command .
alter table tablename move tablespace storage(----_);
you can move this on the same tablespace also.
this way if a table has lots of delets can be defragmented...
for index do rebuild...
|
Results 1 to 6 of 6
Thread: fragmentingThreaded View
|
Click Here to Expand Forum to Full Width |