Re: temporary tablespace usage

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<uo9G9.87191$g9.245220_at_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.

That's right. I did misread your message.

I've never figured out why the datafile-based temporary tablespace can be and by default is labeled LOGGING.

Yong Huang Received on Sat Nov 30 2002 - 21:41:10 CST