Forum Stats

  • 3,875,064 Users
  • 2,266,800 Discussions
  • 7,912,072 Comments

Discussions

deallocate unused space

806692
806692 Member Posts: 4
edited Dec 28, 2010 5:48AM in Advanced Compression
Hi Folks,

I would like to know the difference between these 2 ways of deallocating the unused space.
Can you please provide me the details?

way1:
alter table table_name deallocate unused;

way2:
alter table table_name enable row movement;
alter table table_name shrink space compact;
alter table table_name shrink space;
alter table table_name disable row movement;

Thanks

Answers

  • damorgan
    damorgan Member Posts: 14,464 Bronze Crown
    The docs are at http://tahiti.oracle.com

    After you read the docs, if you still have questions, post a link to what you read and tell us what is confusing.
  • 731759
    731759 Member Posts: 825
    Shrink = below AND above HWM. Deallocate unsued = above HWM only.

    http://sysdba.wordpress.com/2006/04/28/how-to-adjust-the-high-watermark-in-oracle-10g-alter-table-shrink/
    http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/statements_3001.htm

    Thanks
This discussion has been closed.