Re: ALTER TABLESPACE "TEMP" NOLOGGING. Safe?

From: Syltrem <syltrem_at_videotron.ca>
Date: Mon, 26 Feb 2001 16:14:10 -0500
Message-ID: <%Bzm6.6877$C23.74827@weber.videotron.net>

It's already like this.

So even though I get this, it does no logging? 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 - 15:14:10 CST