TEMP tablespace is 99% full...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: TEMP tablespace is 99% full...

Threaded View

  1. #1
    Join Date
    Nov 2000
    Location
    San Diego
    Posts
    24

    TEMP tablespace is 99% full...

    Hi,

    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%) ?

    Thanks,
    -Hidayath
    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