DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to Release the space from Temporary tablespace

Hybrid View

  1. #1
    Join Date
    Jun 2000
    Location
    chennai,tamil nadu,india
    Posts
    159
    How to release the space in temporary tablespace.I was not able to release it.I tried coalesce pct_icrease 0 and 1.It didnt work.

  2. #2
    Join Date
    Feb 2001
    Posts
    389
    which oracle version are u in,
    For dictionary managed tamporary tablespace it would not clear until and unless u restart the database.

  3. #3
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    If you have a temporary segment within, and no user that release it..this is a problem, try this:
    change the next extent of the tablespace storage (bigger than the actual) then try coalesce.
    let me know

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