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

Home -> Community -> Usenet -> c.d.o.server -> Re: Database without temporary tablespace

Re: Database without temporary tablespace

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Sat, 30 Jan 1999 23:49:51 +0000
Message-ID: <36B39A9F.202845AA@rdbms.freeserve.co.uk> 





Hi jbm,



SYSTEM tablespace is the obvious answer, but I would query dba_users to
find which users do their sorting where.



select username,temporary_tablespace


from dba_users;



Chris



"jbmorlaATcalva.net" wrote:


> 


> Hi


> I just inherited a system without temporary tablespace. So where does oracle


> do all the sorts?


Received on Sat Jan 30 1999 - 17:49:51 CST












Original text of this message













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