OraFAQ Forum: Server Utilities » SQL * Loader Problem

Home » RDBMS Server » Server Utilities » SQL * Loader Problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL * Loader Problem [message #244908]

Thu, 14 June 2007 09:51

jackusa
Messages: 6
Registered: May 2007

Junior Member

Hai,
I am using SQL*Loader to insert record from the flat file to table.

My problem is if any line in a file starts with "E" or "W"
i should not insert that record. I need to skip that record move to the next line .
Is it possible to check ... if so pls can u pls send me the sample code.

Thanks In Advance..

Report message to a moderator

Re: SQL * Loader Problem [message #245365 is a reply to message #244908]

Sat, 16 June 2007 08:52

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't have Oracle here to test it, but you might look at the WHEN clause (check the Loading records based on a condition section).

Report message to a moderator

Re: SQL * Loader Problem [message #245366 is a reply to message #244908]

Sat, 16 June 2007 09:17

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

This should help - http://www.orafaq.com/faq/can_one_selectively_load_only_the_records_that_one_need

Report message to a moderator

Previous Topic:	Import from Oracle7 to Oracle 10g
Next Topic:	SQL Loader not starting from Solaris

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 07 19:34:33 CDT 2026