RE: temporary tablespace not emptied , how to?

Thank
you Samir,
<SPAN
class=291553314-25102001> 
yes
this is a temporary tablespace and unfortunatly shutting down the instance and restarting it didn't empty the tablespace. for
info this has maybe some importance , I have a redhat 7.2 with oracle 8.1.7.1
<SPAN
class=291553314-25102001> 
<SPAN
class=291553314-25102001>/Maya

<FONT face=Tahoma

  size=2>-----Original Message-----From: SARKAR, Samir   [mailto:Samir.SARKAR_at_nottingham.sema.slb.com]Sent: Thursday,   October 25, 2001 4:16 PMTo: 'ORACLE-L_at_fatcity.com'Cc:   'maya.kenner_at_trema.com'Subject: RE: temporary tablespace not   emptied , how to?
  Maya,
<FONT

face=Arial> 
  Check whether ur TEMP
  tablespace is of the type Temporary by issuing the following query   :
<FONT

face=Arial> 
   select
  tablespace_name, status, contents from dba_tablespaces where   

  tablespace_name = 'TEMP'
  ;
<FONT

face=Arial> 
   If the TEMP
  tablespace is of type Permanent, the cleanup is performed by SMON after   the process
  using it has been
  completed. If it is of type Temporary, it should get emptied when the instance   is
  shut down and
  restarted.
<FONT

face=Arial> 
  You can check from
  v$sort_segment to see how many of the sort segments r currently using   the
  Temporary
  tablespace.
<FONT

face=Arial> 
  Hope this
  helps.
   
  Samir Sarkar
  Oracle DBA - Lennon
  Team <FONT color=#000080
  face=Impact>SchlumbergerS<FONT
  color=#000080 face=Impact>ema <FONT color=#000080   face=Verdana size=1>Email : samir.sarkar_at_sema.co.uk
<FONT color=#000080 face=Verdana

  size=1>         
  samir.sarkar_at_nottingham.sema.slb.com <FONT   color=#000080 face=Verdana size=1>Phone : +44 (0) 115 - 95   76217 EPABX :
  +44 (0) 115 - 957 6418 Ext. 76217 <FONT color=#000080   face=Verdana size=1>Fax : +44 (0) 115 - 957   6018                 

    <FONT face=Tahoma
    size=2>-----Original Message-----From: Maya Kenner     [mailto:maya.kenner_at_trema.com]Sent: 25 October 2001     14:20To: Multiple recipients of list ORACLE-LSubject:     temporary tablespace not emptied , how to?     <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<FONT size=3>___________________________________________________________________________This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received thisemail in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited.If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600.___________________________________________________________________________