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

[Message index]

		How to skip last n no of records in sql Loader load By: 9390512774 on Wed, 03 August 2011 03:06
		Re: How to skip last n no of records in sql Loader load By: Michel Cadot on Wed, 03 August 2011 03:13
		Re: How to skip last n no of records in sql Loader load By: Littlefoot on Wed, 03 August 2011 04:11
		Re: How to skip last n no of records in sql Loader load By: Michel Cadot on Wed, 03 August 2011 05:13
		Re: How to skip last n no of records in sql Loader load By: joy_division on Wed, 03 August 2011 08:11
		Re: How to skip last n no of records in sql Loader load By: Michel Cadot on Wed, 03 August 2011 08:21
		Re: How to skip last n no of records in sql Loader load By: LKBrwn_DBA on Wed, 03 August 2011 09:19

Previous Topic:	Export import method
Next Topic:	Clone Database user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 00:06:58 CDT 2024