OraFAQ Forum: Server Utilities » How to skip last n no of records in sql Loader load

Home » RDBMS Server » Server Utilities » How to skip last n no of records in sql Loader load (ORACLE 10gR2 linux)

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

How to skip last n no of records in sql Loader load [message #518326]

Wed, 03 August 2011 03:06

9390512774
Messages: 103
Registered: January 2011
Location: hyd

Senior Member

Hi All

I have data file emp.dat in that i have 10000 records.
My requirement is i want to skip last 100 records when i am loading it into EMP table using SQL *LODER.
Please provide me a solution.

Thanks in advance

Report message to a moderator

Re: How to skip last n no of records in sql Loader load [message #518329 is a reply to message #518326]

Wed, 03 August 2011 03:13

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Have a look at SKIP option.

Regards
Michel

Report message to a moderator

Re: How to skip last n no of records in sql Loader load [message #518336 is a reply to message #518329]

Wed, 03 August 2011 04:11

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

Senior Member
Account Moderator

SKIP makes it possible to, well, skip records at the beginning of the file, not at the end.

So ... maybe you could remove records you don't need BEFORE running SQL*Loader (i.e. delete them in a text editor)? Or, if you can distinguish those records from the others (by some kind of an ID or whatever), you might try with the WHEN clause. Or, instead of SQL*Loader, use external tables concept which provides larger flexibility.

Report message to a moderator