Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Looking for "auto commit count" feature

Re: Looking for "auto commit count" feature

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 9 Dec 2000 09:33:52 -0000
Message-ID: <976354281.12991.0.nnrp-09.9e984b29@news.demon.co.uk>

Depending on requirements, you could change the table to a NOLOGGING table (alter table XXX nologging) then do a direct mode insert:

insert /*+ append */ into XXX
select etc.

There are several restrictions though, which may make this approach unsuitable.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
Book bound date: 8th Dec 2000
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Frugal Sam wrote in message <3A31C07C.C5151B5D_at_hotmail.com>...

>Hi all
>
>We have a statement to the effect :
>
>INSERT into tablename_1
>(SELECT ..... from tablename_2)
>
>We cannot use a cursor and commit every n records. The statement is
>executed and results in 5 million rows being copied from tablename_1 to
>tablename_2. As a result, we need very large rollback statements which
>we want to avoid.
>
>Is there some init parameter we can set when our database instance
>starts up that would tell Oracle to perform a COMMIT say every 100,000
>rows ?
>
>Thanks.
>
Received on Sat Dec 09 2000 - 03:33:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US