DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2008
    Chandigarh, India

    shrink space in tablespace

    We have a table named MAM_ASSETS, one of whose columns is BLOB. We have the option to keep our files in BLOB form or store them on a file server and keeping the link somewhere in other column of MAM_ASSETS.

    We provide the option to move data from BLOB column to file server that vacates space. BLOB column data is stored in some tablespace.

    When we move the data from BLOB column to file server, the space in BLOB tablespace is not released. Is there a way to release this space?

  2. #2
    Join Date
    Dec 2002
    How did you move the data from BLOB?. Did you update the column with empty space?

  3. #3
    Join Date
    Jan 2007
    Dayton, OH
    Try this:

    alter table MAM_ASSETS enable row movement;
    alter table MAM_ASSETS deallocate unused;
    alter table MAM_ASSETS shrink space;

    This will only work if the tablespace has segment space management set to auto. It's not a true reclaim of space, but in the right situation, it will. Check out doc ID 820043.1 on metalink, it's fairly comprehensive on this. Or check out http://www.dbasupport.com/oracle/ora...e_shrink.shtml

    Hope this helps,


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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.