Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Insert w/o redo log , Oracle 8i
hi from Paris
options to do 'nologging' operations:
- CTAS (create table as select) - alter table/index ..... nologging - sqloader
Other ways: not possible.
"rs" <info_at_bytelife.com> a écrit dans le message de
news:3ec3e666$0$45382$1b62eedf_at_news.wanadoo.nl...
> 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 Sat May 17 2003 - 19:02:55 CDT