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

xtanto_at_hotmail.com wrote:

> How can I do COMMIT for every 10,000 rows ?
>
> Thank you for your help,
> Krist

Why would you want to? In a well designed database there should be no need to even ask the question.

So rather than asking for a kludge ... have the DBA fix the root cause of the ORA-01555's.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)