Re: Insert append nologging

Anurag Varma schreef:
> Here:
>
> http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14223/usingpe.htm#sthref2545
> <quote>
> The default logging attribute is LOGGING. However, if you have put the
> database in NOARCHIVELOG mode, by issuing ALTER DATABASE NOARCHIVELOG,
> then all operations that can be done without logging will not generate
> logs, regardless of the specified logging attribute.
> </quote>
>
> and Metalink Note:212119.1
>
> Anurag
>

can != will.
It simply does not say "will be done".

And the note is about direct load inserts; I thought it was well documented direct loads generate less redo. Note 188691.1 shows which operations can make use of nologging in order to prevent redo generation; switching into noarchivelog mode is not mentioned.

The point is the append hint will cause less redo to be generated, not the fact that you run in noarchivelog mode. So in the context of the original question, archivelog has nothing to do with the amount of redo generated.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...