Re: Transaction without redolog

From: Iain Knowles <i.knowles_at_ntlworld.com>
Date: Mon, 7 Jan 2002 21:17:34 -0000
Message-ID: <Sfo_7.7738$6q2.1943778@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

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.
>
>
Received on Mon Jan 07 2002 - 15:17:34 CST