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

No, but .... try the
  insert /*APPEND */
hint and you'll be surprised how much faster it is.

And "appends" data at the end of your table- no problem because you just truncated it so you'll start filling it at the start.

On a filled table it will allocate new extents instead of reusing free space from deleted row... so don't do a "delete" followed by insert /*APPEND */

Read up on it - works great.

cheers

     Roelof Schierbeek

R.Schierbeek, DBA

Markus Kunze <markus.kunze_at_sdm.de> schreef in
> Hi all,
> is it possible to do an insert-statement without writing a redo log?
> that means to switch logging off during a transaction
>
> 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
Received on Thu May 15 2003 - 14:10:44 CDT