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

Hi Antoine,

There is other options for "nologging" operations :

• direct load (SQL*Loader)
• direct-load INSERT
• CREATE TABLE ... AS SELECT
• CREATE INDEX
• ALTER TABLE ... MOVE PARTITION
• ALTER TABLE ... SPLIT PARTITION
• ALTER INDEX ... SPLIT PARTITION
• ALTER INDEX ... REBUILD
• ALTER INDEX ... REBUILD PARTITION
• INSERT, UPDATE, and DELETE on LOBs in NOCACHE NOLOGGING mode stored out of line

Note on metalink : 188691.1

Dias

"Antoine BRUNEL" <antoinebrunel/yahoo.fr> wrote in message news:<3ec6cdaf$0$17509$79c14f64_at_nan-newsreader-02.noos.net>...
> 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 Sun May 18 2003 - 01:57:17 CDT