| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ALTER TABLESPACE "TEMP" NOLOGGING. Safe?
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 Fri Feb 23 2001 - 22:32:16 CST
 |
 |