Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: table nologging in 8i
"Steve Haynes" <steve_at_rwx777.demon.co.uk> wrote in message news:+OIoeyAPMwh5EwT6_at_rwx777.demon.co.uk...
I may be mis-understanding your answer here, Steve, but since the syntax is 'alter table emp nologging', the idea that you can't put a table into no logging mode is incorrect. Once issued, no subsequent DML statements on that table will generate redo, until you explicity issue the 'alter table emp logging' statement.
You can even create an entire tablespace in nologging mode (hence all segments created within the tablespace will not generate redo).
Regards
HJR
> It doesn't matter which dictionary views you are using, you
> won't see any redo reduction just because you ran a nologging
> *statement* previously.
>
> Steve
Received on Wed Aug 02 2000 - 00:00:00 CDT