Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Tools > sqlldr: setting...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 2703 of 2771
Post > Topic >>

sqlldr: setting NULL instead of rejecting record

by Mathias Waack <M.Waack@[EMAIL PROTECTED] > Feb 3, 2008 at 09:42 AM

Hi all, 

I'm going to im****t 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
 




 2 Posts in Topic:
sqlldr: setting NULL instead of rejecting record
Mathias Waack <M.Waack  2008-02-03 09:42:01 
Re: sqlldr: setting NULL instead of rejecting record
"fitzjarrell@[EMAIL   2008-02-04 06:11:13 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Wed Jul 9 0:29:38 CDT 2008.