deallocate unused
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: deallocate unused

  1. #1
    Join Date
    Aug 2000
    Posts
    163

    Wink

    I've searched the forums wanting to find as much information as I can about hight water mark and re-claiming unused space.
    There seems to be two solutions:
    1. export/import
    2. 'alter table deallocate unused' command.
    There is some discussion about 'deallocate unused' not always being able to re-gain unused space.
    It is true?
    Thank you.

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Yes, it is true becuase, oracle does not allocate contiguous memory blocks. If the occupied block is just near the end, then shirnking the file does not really shrink. So, only the option will be export, recreate the tablespace and import with the right storage parameters.
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Aug 2000
    Posts
    163
    So, is there any situation I would be able to use 'deallocate unused'?
    Everyone suggests to use export/import.
    Thank you.

  4. #4
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Try using Deallocate first. If no data is sitting at end of the file, then Deallocate should work and you can shrink the file. If it does not work then you have no other option accept taking exp/imp
    Thanks
    Kishore Kumar

  5. #5
    Join Date
    Mar 2000
    Location
    Sydney
    Posts
    9
    Mary,
    Deallcate unused is only used when say for example a segment has allocated an extent of 1GB and occupies only 100 MB out of that. Now you can find other segments can only occupy the space beyond this 1GB. If you don't want this to happen then you can say Alter table...... Deallocate unsed so that the extent will shrink to only 100 MB that's been allocated for the segment.

    Hope it helps.
    GK

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width