Re: Insert w/o redo log , Oracle 8i

Markus Kunze wrote:

> Hi all,
>
> is it possible to do an insert-statement without writing a redo log?
> that means to switch logging off during a transaction (not for the whole
> db).
>
> I use "truncate table" instead of "delete * from table".
> But when it comes to refill the truncated tabel i use the insert statement
> and by doing this, i write a redo log, that i actaully don't need.
>
> cheers and thanks
>
> Markus

No!

And you are incorrect that you don't need the redo logs. What you are actually stating is that you don't understand what they are and how they work so I would encourage you to explore their purpose at http://tahiti.oracle.com.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)