Re: table nologging in 8i

I went through this issue about a month ago. The response from Oracle was as follows:

concepts manual ch21 addresses this issue:

ct needs to do:

insert /*append*/ into emp
select <cols> from <other_table>;
commit;

The append hint causes oracle to do a direct load of the data into the table. It seems that only direct operations avoid the redo logging. Once I added this statement to my insert operation, the truckload of redo that I was getting went away.

"Yong" <yhuang_at_indigopool.com> wrote in message news:8mbu4c$40h$1_at_news.sinet.slb.com...
> Additional confusion about nologging has an answer from Thomas Kyte now:
>
> http://osi.oracle.com/wa/ask/owa/ask_tom_pkg.display?p_dispid=485221567528
>
> Yong Huang
>
> Tom Best <tom.best_at_bentley.com> wrote in message
> news:8m4o0s$fl5$1_at_news.bentley.com...
> > Ted:
> >
> > No.
> >
> > HTH,
> > Tom Best
> >
> > <tedchyn_at_yahoo.com> wrote in message news:8m4klh$cd3$1_at_nnrp1.deja.com...
> > > Sir: If a table is altered with nologging option, would subsequent
> > > delete/update logged using oracle 8i ?
> > > thanks in advance
> > > ted chyn
> > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> >
>
>
Received on Mon Aug 07 2000 - 00:00:00 CDT