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: temporary tablespace usage

Re: temporary tablespace usage

From: Yong Huang <yong321_at_yahoo.com>
Date: 30 Nov 2002 08:39:54 -0800
Message-ID: <b3cb12d6.0211300839.59dddf3b@posting.google.com> 





"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<mFPF9.86504$g9.243485_at_newsfeeds.bigpond.com>...


> To be certain, what is the output from dba_tablespaces for your temp

> tablespace? If it says 'LOGGING' for it, its a temporary tablespace of the

> first sort.




By default, that's true. But a traditional temporary datafile can be
made nologging as well.



Yong Huang
Received on Sat Nov 30 2002 - 10:39:54 CST












Original text of this message













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