Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> temporary tablespace not emptied , how to?

temporary tablespace not emptied , how to?

From: Maya Kenner <maya.kenner_at_trema.com>
Date: Thu, 25 Oct 2001 05:31:11 -0700
Message-ID: <F001.003B414B.20011025052019@fatcity.com> 







<SPAN 



class=354450612-25102001>Hello,


<SPAN 



class=354450612-25102001> 


My "TEMP" temporary 


tablespace does not get emptied , I thought rebooting would drop all the 
temporary objects stored in it but it does not, any idea why and how to empty it 
?


Alternative 


question:


- is there a way to 


know which objects are in the TEMP tablespace
- does oracle do 


redo logs when working in temporary segments ?


<SPAN 



class=354450612-25102001> 


Thanks, 


Maya
Received on Thu Oct 25 2001 - 07:31:11 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US