Re: Transaction without redolog

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 8 Jan 2002 00:10:14 -0800
Message-ID: <a8aed4.0201080010.461b3975@posting.google.com>

"Iain Knowles" <i.knowles_at_ntlworld.com> wrote in message news:<Sfo_7.7738$6q2.1943778_at_news2-win.server.ntlworld.com>...
> For inserts you can always use the APPEND hint
>
> i.e. insert /*+ append */ into ...........
>
> This virtualy eliminates redo for this type of operation
No It Does Not ... U Should Not have aby References on the Table and tthere shoud be no triggers.

U should also have created the table with NOLOGGING Clause.

The Append Hint can only be used for Insert Into select * from .

>
> Iain
>
> "Elías Alpuente" <ealpuente_at_isoco.com> wrote in message
> news:a14gn0$nb7$1_at_talia.mad.ttd.net...
> > We have a PL/SQL program that generate a lot of redo log data. Each time
> the
> > archiver
> > make its job we have 3 Gb in the arc directory.
> >
> > Is posible make a transaction without generate redolog data with
> ARCHIVELOG
> > mode?
> >
> > Thanks.
> >
> >

Regards,
Ganesh R Received on Tue Jan 08 2002 - 02:10:14 CST