Re: temporary tablespace usage

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sun, 1 Dec 2002 07:51:10 +1100
Message-ID: <uo9G9.87191$g9.245220@newsfeeds.bigpond.com>

"Yong Huang" <yong321_at_yahoo.com> wrote in message news:b3cb12d6.0211300839.59dddf3b_at_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.

You've missed the point. Whether it's the default or not, if it says logging then it is definitely a datafile temporary tablespace. If it says 'nologging', then fair enough: further investigation is required, because yes, its status could have been changed.

But none of that makes what I wrote wrong.

>But a traditional temporary datafile can be
> made nologging as well.
>

But a tempfile temporary tablespace can not be made logging.

And that was my point.

HJR
> Yong Huang
Received on Sat Nov 30 2002 - 14:51:10 CST