I saw an interesting option in Oracle 10gR2
adding an error logging clause to Insert statement

I know we plan to implement effective mass data load ability
but this option is perhaps a good way too to proceed
in conjunction with external tables
cf oracle article :
<http://www.oracle.com/technology/oramag/oracle/06-mar/o26performance.html>


--
Philippe Makowski

Firebird serveur SQL open-source en français http://firebird-fr.eu.org

Ma clé PGP : http://makowski.eu.org/pgpkey.html