On 28 feb, 10:51, Jerome Vitalis <vitalismanN0S..._at_gmail.com.invalid>
wrote:
> sybrandb wrote:
> > On Feb 28, 9:21 am, "astalavista" <nob..._at_nowhere.com> wrote:
> >> Hi,
>
> >> I have to insert a big table into another (9.2.0.4 ):
> >> insert /*+ append */ into T1 select * from from T2 nologging;
>
> >> I have 2 questions:
> >> - if T1 is empty, is /*+ append */ of any interest ?
> >> - if the database is NOT in ARCHIVELOG, is nologging of any interest ?
>
> ...
> > 2 Apart from being utterly undesirable, NOARCHIVELOG does NOT stop the
> > logging mechanism, it just means the oldest online redolog is
> > overwritten when you run out of online logs.
>
> But in NOARCHIVELOG mode, using the append hint does prevent redo
> generation, even if the table is in LOGGING mode.
The point is that NOARCHIVELOG and LOGGING (or the append hint)
have nothing to do with eachother.
Received on Wed Feb 28 2007 - 04:22:52 CST
