Re: Insert without redo log

"Paul Martin" <prmartin_at_bluewin.ch> wrote in message news:96eftq$946$1_at_bw107zhb.bluewin.ch...
> Hello
>
> This question might/does sound a bit strange :
>
> Is there a way to do an Insert/Update without generating any redo log
 data.
> I would like the same reaction
> as a Truncate - no rollback data, no redo log data - but for either an
> Insert or a Transaction.
>
> The reason behind this question is that we have a batch process that
 inserts
> records into a temporary
> table. If possible we don't want these inserts in the redolog data (or
> rollback) because they will not be needed
> even if the system crashes.
>
> Anybody got any ideas ?
>
> Many thanks
>
> Paul
>
>
>

Use the /*+APPEND*/ hint
This will insert data after the highwater mark, so your indexes are going to be in need of a rebuild.

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Feb 14 2001 - 13:36:32 CST