Wednesday, January 30, 2008

ALTER TABLE ... MOVE - Negative result

We know that ALTER TABLE ... MOVE compacts and repacks the data in a table which had seen too many DELETE operations. The following link shows instances where the impact is contrary and the reason for the same.

http://www.freelists.org/archives/oracle-l/07-2004/msg01670.html

No comments: