OraFAQ Forum: Server Utilities » sql* loader (merged)

Home » RDBMS Server » Server Utilities » sql* loader (merged)

Fri, 01 May 2009 05:40

ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad

Senior Member

How can we insert records from 10 to 15 only using SQL*LOADER.Please give me control file for that.

Fri, 01 May 2009 05:45

ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad

Senior Member

How can we we insert only records 2,5,6,9 using SQL*LOADER please give me control file for that.

Fri, 01 May 2009 05:48

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

Senior Member
Account Moderator

The first part is easy - use SKIP option to skip first 9 records. I wouldn't know how to limit number of loaded records.

Fri, 01 May 2009 05:52

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

Senior Member
Account Moderator

Can you tell us what you already tried?
Can you tell us if you read the documentation?

Regards
Michel

Fri, 01 May 2009 12:51

Barbara Boehmer
Messages: 9088
Registered: November 2002
Location: California, USA

Senior Member

If you have a column with a record number, then you can use WHEN to load only the rows you want, based on the record number.

Previous Topic:	SQL Loader to load single row into multiple rows
Next Topic:	CREATE a db using import command line

Goto Forum:

]

Current Time: Thu Apr 18 06:57:08 CDT 2024