The only thing I can think of is that Index (re)builds may use the temporary
tablespace. I can't recall if these operations are logged or not. Otherwise
I agree seems to make no sense.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Nuno Souto" <nsouto_at_nsw.bigpond.net.au.nospam> wrote in message
news:3b14e5a9.10203170_at_news-server...
> V8.0.x and V8.1.x:
>
> Is there any advantage/problem/whatever in setting a tablespace
> defined as TEMPORARY, also as NOLOGGING?
>
> I can't for the life of me see why NOLOGGING or LOGGING would be
> relevant for a TEMPORARY tablespace, but someone at work asked and I
> couldn't find anything saying yay or nay in the doco. And if I try to
> set a TEMPORARY tablespace as NOLOGGING, it lets me.
>
> TIA for any insights.
>
> Cheers
> Nuno Souto
> nsouto_at_bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
Received on Wed May 30 2001 - 07:57:15 CDT
