sqlldr: setting NULL instead of rejecting record
From: Mathias Waack <M.Waack_at_gmx.de>
Date: Sun, 03 Feb 2008 09:42:01 +0100
Message-ID: <pbbg75-e55.ln1_at_valpo.de>
[Quoted] Hi all,
Date: Sun, 03 Feb 2008 09:42:01 +0100
Message-ID: <pbbg75-e55.ln1_at_valpo.de>
[Quoted] Hi all,
I'm going to import a table into oracle by using sqlldr. The table contains some cells with wrong contents, for instance number fields with text or date fields with invalid dates. sqlldr rejects these records. Is there an option the tell sqlldr to just set wrong values to NULL intead of rejecting the whole record?
Thanks,
Mathias Received on Sun Feb 03 2008 - 09:42:01 CET