RE: TEMP tablespace not Freeing the space

  • From: "Nilesh Shah" <nshah@xxxxxxxxxxx>
  • To: <ravi.madabhushanam@xxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
  • Date: Wed, 21 Jun 2006 17:25:44 -0700

Db version? Temp tablespace type LOCAL/Dictionary



From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ravi Madabhushanam
Sent: Wednesday, June 21, 2006 4:43 PM
To: Oracle-L@xxxxxxxxxxxxx
Subject: TEMP tablespace not Freeing the space


Hi all,

          In our Development system, We have a TEMP tablespace. 

          Just now we got the message that "Unable to extend TEMP

          We have bounced the database to free up this tablespace. But,
even then it is not freeing any space. 

          Can any one tell me how to go about this with out adding any


          Please reply soon.. any help would be greatly appereciated.




Other related posts: