Re: insert as select with "save exceptions"

On 24 Jul 2005 02:08:19 -0700, yonimoshe_at_gmail.com wrote:

>Is there a way , while doing "insert as select", to keep rejected rows
>in a certain table and continue on with bulk insert?
>I know you can do that through pl/sql with collections, but that would
>slow my load.

constaints have an 'exceptions into clause' which saves the rowid's of the rejected rows.
Other than that, I always make sure my data is clean prior to the bulk insert. I know this strategy works.

--
Sybrand Bakker, Senior Oracle DBA