How to claim unused space in datafile - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: How to claim unused space in datafile

  1. #11
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    I have a gut feeling some lock is being held on one/many blocks of the moved table on the old tablespace. Since you are the only one in the database, can you bounce the database and check the segments status?
    Thanx
    Sam



    Life is a journey, not a destination!


  2. #12
    Join Date
    Nov 2000
    Location
    Atlanta, GA, USA
    Posts
    85
    Sambavan,
    I'm at a loss here. The space has still not been freed even after I bounced the database. I even restarted the server just in case. I guess the only thing left for me to try is to export the user, drop user cascade, and check if the space is freed. Then import the user back.
    Thanks for all your help

  3. #13
    Join Date
    Nov 2005
    Location
    Indianapolis
    Posts
    24

    Still not clear

    It's hard to say without seeing the output from sqlplus. What objects does Oracle report being in TS_01? Is it possible the indexes are still there?

    Not sure if this will help, but here is a script that I use to see what the extents look like in my datafiles.

    Maybe you've ran into a bug? I've never seen this behavior before.
    Attached Files Attached Files

  4. #14
    Join Date
    Nov 2000
    Location
    Atlanta, GA, USA
    Posts
    85
    I was finaly able to reclaim the unused space by droping the user and importing it back. Thanks all for your help and time. The one information I left out was this db was setup as one of the standby databases for prod and got activated a couple of days ago to be used as a dev server. I wonder if the free space could not have been reclaimed due to this, but again I could reclaim the space when I move other tables owned by this same user. I was only having problem with this one huge table.
    Thank you

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