Table Re-organization: Alter table move method not working
808686Dec 19 2011 — edited Dec 19 2011Hi Experts,
Iam working on Oracle 10.2.0.5 Standard Edition Database on Windows 2003 server. We perform table re-organization using the "alter table move" method and later rebuild the unusable indexes.
But this method does not seem to be working. The unused space does not seem to decrease after performing the activity. Also I cannot go ahead with the "shrink" method because the tablespace segment space management is manual and not AUTO.
Also, online method is not supported by Standard Edition. Please help me out in understanding why the "alter table move" method not working.