Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question re temporary tablespace
of course you can specify nologging in a create index statement. oops.
-- Niall Litchfield Oracle DBA Audit Commission UK "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3b14ee30$0$15030$ed9e5944_at_reading.news.pipex.net...Received on Wed May 30 2001 - 08:40:41 CDT
> 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
>
>