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

From: Mike Cretan <nospamthanks_at_nowhere.com>
Date: Mon, 28 Mar 2005 22:30:27 GMT
Message-ID: <7A%1e.15970$C7.5800@news-server.bigpond.net.au>

Performance issues aside (and I agree that a single SQL statement with or without hints would be best in this regard), it appears that this users' principal concern is porting data from one database to another.

The PL/SQL solution offers more flexibility with exception handling & job restarting than a single SQL statement, and by the time they have worked through all the rollback too small/snapshot too old issues, they'd have been better off with the slower & more predictable outcomes that PL/SQL provides.

Cheers,

Mike Cretan Received on Mon Mar 28 2005 - 16:30:27 CST