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

Threaded View

  1. #1
    Join Date
    Nov 2000
    San Diego

    TEMP tablespace is 99% full...


    We are on W2K with 8i.

    We have a TEMP tablespace defined as 'Temporary'. Size 5 GB.

    Today I see it is about 99% used. I belive some one ran a huge query. Now my question after the temp tablespace is used by the oracle for sorting, and the work is completed, does it not return the space back ? If not, how do we get back the unused space (inactive space).. I don't know what word should I use here for this space. Or How do I free the space ?

    If someone wants to run a similar query/report will they get an error just becaue it is already 99% used or this new query would make use of the already filled but inactive tablespace(99%) ?

    Last edited by Hidayath; 05-27-2003 at 05:44 PM.

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.