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: INSERT millions_of_rows, how to COMMIT every 10,000 rows ?

Re: INSERT millions_of_rows, how to COMMIT every 10,000 rows ?

From: Anurag Varma <avoracle_at_gmail.com>
Date: 28 Mar 2005 14:03:04 -0800
Message-ID: <1112047384.848993.317040@z14g2000cwz.googlegroups.com>


David,

  1. You are using the wrong syntax. Note that the post you are referring to has append hint just after insert. You however are using it after select. its insert /*+ append */ into newtable select * from old table;

      not

       insert into newtable select /*+ append */ from oldtable;

2. The rollback used is *minimal/near zero* .. its not zero as being claimed.

Anurag Received on Mon Mar 28 2005 - 16:03:04 CST

Original text of this message

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