This is the best way to defrag a table:
alter table tablename
move tablespace tablespacename
But be careful doing this means the table's indexes will become unstable and so you need to rebuild all the indexes again:
ALTER INDEX index_name REBUILD
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment