Re: management paranoia about 2 million rows updated in 1 commit
From: Tim Hall <tim_at_oracle-base.com>
Date: Wed, 22 Aug 2012 20:28:20 +0100
Message-ID: <CAP=5zEgtGe1=eqB6BohHd3mU26nFgTgMxCL0FvytrMjF+ZU59g_at_mail.gmail.com>
When using a single statement, it's a bummer if you get to last row, it fails and everything is rolled back. Fortunately, DML Error Logging was invented. :)
Date: Wed, 22 Aug 2012 20:28:20 +0100
Message-ID: <CAP=5zEgtGe1=eqB6BohHd3mU26nFgTgMxCL0FvytrMjF+ZU59g_at_mail.gmail.com>
When using a single statement, it's a bummer if you get to last row, it fails and everything is rolled back. Fortunately, DML Error Logging was invented. :)
http://www.oracle-base.com/articles/10g/dml-error-logging-10gr2.php
Cheers
Tim...
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 22 2012 - 14:28:20 CDT