Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ALTER TABLESPACE "TEMP" NOLOGGING. Safe?
Syltrem wrote:
> It's already like this.
>
> So even though I get this, it does no logging?
There is some minimal logging for all operations, but temporary segments
don't create log records like
all regular segments do. So changing tablespace to nologging, even if it
possible (I don't know), won't
change anything. I hope you don't try to create permanent object in that
tablespace!
>
> select tablespace_name, contents, logging from dba_tablespaces;
>
> TABLESPACE_NAME CONTENTS LOGGING
> ------------------------------ --------- ---------
> SYSTEM PERMANENT LOGGING
> MANUFACTURING PERMANENT LOGGING
> TEMP TEMPORARY LOGGING
> ..
> .
> .
>
> --
>
> Sytrem
> http://pages.infinit.net/syltrem
>
> "Alex Filonov" <afilonov_at_pro-ns.net> a écrit dans le message news:
> 3A97394D.37B2E0DF_at_pro-ns.net...
> > Syltrem wrote:
> >
> > > Everything is in the subject!
> > >
> > > Thanks!
> > >
> > > --
> > >
> > > Sytrem
> > > http://pages.infinit.net/syltrem
> >
> > You don't need it if you TEMP tablespace is temporary. In that case
> > everything written into this
> > tablespace automatically has nologging attribute. It also can't be
> > rolled back. So, do this instead:
> >
> > ALTER TABLESPACE TEMP TEMPORARY;
> >
> >
> >
Received on Mon Feb 26 2001 - 22:13:13 CST