disk space increased dramatically after table move
905444Jan 11 2012 — edited Jan 11 2012I am using Oracle 10G
I found there is a big table which has high fragmentation problem, therefore I tried table move today:
alter table TAB_A move;
After the table has been moved
I found two problems:
1) The indexes are unusable
2) The disk size has increased dramatically
The 1st problem I know, cuz the rowid has been changed, I am now rebuilding indexes, that is ok, but how can I reclaim the space?
I know I can shrink the table, but would anybody knows would the rowid has to be changed again?
I cannot suffer the loading of rebuilding indexes again today, cuz the staff will start to work very soon, but I have to deal with the space problem, cuz the space size alert has been triggered.
Thanks a lot