Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Can SQL*Loader do this?

Can SQL*Loader do this?

From: yong huang <yong321_at_yahoo.com>
Date: Thu, 24 Aug 2000 14:33:26 -0700 (PDT)
Message-Id: <10599.115512@fatcity.com>


If SQL*Loader can't load a row of data because of integrity constraint violation, can I ask SQL*Loader to change one value and continue to load this row? I.e., if it can't load "1,John,Doe," because 1 is already taken, can it auto increment 1 to 2 and try loading "2,John,Doe,"? If that fails again, increment 2 to 3 and try once more.

Yong Huang
yong321_at_yahoo.com



Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/ Received on Thu Aug 24 2000 - 16:33:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US