Home » RDBMS Server » Server Utilities » sql* loader (merged)
sql* loader (merged) [message #401050] Fri, 01 May 2009 05:40 Go to next message
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.
SQL*LOADER insert [message #401053 is a reply to message #401050] Fri, 01 May 2009 05:45 Go to previous messageGo to next message
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.
Re: sql* loader [message #401054 is a reply to message #401050] Fri, 01 May 2009 05:48 Go to previous messageGo to next message
Littlefoot
Messages: 20900
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.
Re: sql* loader (merged) [message #401056 is a reply to message #401050] Fri, 01 May 2009 05:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
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
Re: SQL*LOADER insert [message #401118 is a reply to message #401053] Fri, 01 May 2009 12:51 Go to previous message
Barbara Boehmer
Messages: 8635
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: Wed Dec 07 16:13:41 CST 2016

Total time taken to generate the page: 0.10329 seconds