Re: Can SQL*Loader do this?

Not as far as I know. SQL*Loader is a basically a serial process data loader, you can perform various things as you go, but not iteratively.

You could certainly handle what you want to do with PLSQL and UTL_FILE but performance could be a problem if the data is non-trivial.

Depending on volumes I would choose to use SQL*Loader to load the data into an intermediate table without primary/unique constraints.

Then use PLSQL to match the data into the real data table.

regards

Rod

-- 
Rod Corderey

Lane Associates
RodCorderey_at_Lane-Associates.com
http://www.Lane-Associates.com

yong huang wrote:


> 

> 

> 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/

> --

> Author: yong huang

>   INET: yong321_at_yahoo.com

> 

> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing Lists

> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message

> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> the message BODY, include a line containing: UNSUB ORACLE-L

> (or the name of mailing list you want to be removed from).  You may

> also send the HELP command for other information (like subscribing).