Insert without redo log

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 Received on Wed Feb 14 2001 - 11:38:20 CST