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:41:45 -0800
Message-ID: <1112049705.088853.222010@l41g2000cwc.googlegroups.com>

set autocommit <n>

in sqlplus will issue a commit after n insert, delete, update or pl/sql block executions.

You seem to be indicating that oracle will commit after n rows inserted.
Not so!

Anurag Received on Mon Mar 28 2005 - 16:41:45 CST

This message: [ Message body ]
Next message: smauldin_at_ingrian.com: "Concurrency problem with INSTEAD OF trigger"
Previous message: Mike Cretan: "Re: INSERT millions_of_rows, how to COMMIT every 10,000 rows ?"
In reply to: rbs: "Re: INSERT millions_of_rows, how to COMMIT every 10,000 rows ?"
Next in thread: DA Morgan: "Re: INSERT millions_of_rows, how to COMMIT every 10,000 rows ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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