Skip to Main Content
  • Questions
  • How to use the SQL*Loader in Oracle Apps

Breadcrumb

Question and Answer

Tom Kyte

Thanks for the question, Jyotirmoy.

Asked: October 20, 2009 - 4:57 am UTC

Last updated: December 14, 2012 - 2:01 pm UTC

Version: 11.5.10.2

Viewed 10K+ times! This question is

You Asked

Hi,

I want to insert the data from a csv file to a table.
Is it possible to insert the data from client side using this Execution Method.

Please let me know how I use this execution method (SQL*Loader) in oracle Apps.

Thanks in advance.

Regards,
Jyotirmoy

and Tom said...

sqlldr is just a command line tool.

If you have a file on your client machine (the .csv)

and you have the Oracle client and tools installed (so that sqlldr is there, present on your client)

Then yes, you can just use sqlldr from the command line:

$ sqlldr userid=user/pass@database control=your_control_file.ctl data=your_csv_file.csv

Rating

  (8 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Easy to do

A reader, October 21, 2009 - 6:09 am UTC

Create your control file (e.g. my_control.ctl) and put it in the appropriate directory on the application server (if I recollect correctly it should be in $<module>_TOP/bin, but you should be able to figure that out from the documentation). Then create a concurrent program executable of type 'Sqlloader' and enter 'my_control' as execution file name. Then define a concurrent program using this executable.

There should be some examples out on the internet if you want to pass the datafile as a parameter.

Good luck

How to use the SQL*Loader in Oracle Apps", version 11.5.10.2

Sugam Ghosh, December 01, 2009 - 7:00 am UTC

Hi Guys,

am somewhat confused vid the second one, is it applicable when we don't have a previledge to run sqlldr from client machine.. please advice. 
coz it is following the same way of registering a concurrent program what we use to call from apps end to perform any job.

regards,
Sugam

SQL Loader or Dataload Pro for R12 E-Business Suite bulk loads

Stuart King, March 05, 2010 - 7:46 am UTC

We require to run many bulk loads into E-Business modules.
I have read a bit about Dataload Pro and seen a few testimonials. Everyone seems to sing its praises.
This is a pre-production build, but will go live in the next few months and we are pondering over whether we should productionise this tool for E-Business suite or not?

However, can SQL Loader be used to the same effect.
Our current standard method for data loading into Oracle is SQL Loader.
Does it have limitations in that its just not an effective tool with E-Business quite in mind?

Any advice appreciated.

Tom Kyte
March 05, 2010 - 11:33 am UTC

I have no experience, no even knowledge really, of this tool. sorry.

A reader, April 12, 2010 - 1:17 am UTC

Hi Please could some one explain the steps from the starting to the Ending

The Steps

Greg, April 13, 2010 - 1:18 pm UTC

Now *THAT* is funny!!!! Thanks for a laugh on a too busy day

We missed you, Tom

Adam, April 13, 2010 - 2:56 pm UTC

I get the feeling that Tom's sense of humor was restored after a week away from "Ask Tom". Honestly, I don't know how he maintains his patience most days.
Tom Kyte
April 14, 2010 - 8:04 am UTC

A week away was a week in South Africa - after one of the longest flights ever, three days in a row of 5 hour seminar followed by customer visits ;) good to be back home for a week....


long flight

Greg - Apps dba, April 14, 2010 - 12:37 pm UTC

A friend of mine was flying from Durban SA to NY, a very long flight. He as a smoker and was at the back of the plane in the smoking section. He was had the aisle seat and a small man who did not speak English was sitting next to him. He spent the entire flight sleeping on my friend's shoulder but would periodically wake up and smoke his cigarettes! He didn't ask or gesture, just took them...

At least he got a good story out of it.

As far as loading information into the database, we use a concurrent job and treat the csv files as external tables. They just get put out there in a generic file.

Intercompany Transaction flow between two OUs

A reader, December 06, 2012 - 12:54 am UTC

Intercompany Transaction flow between two OUs, Could some one explain the same clearly interms of functional as wll as technical.
Tom Kyte
December 14, 2012 - 2:01 pm UTC

what the heck is an "OU"

I hear Oracle University in my head when I hear OU. But I'm pretty sure that isn't what you meant.


and what do you mean by "intercompany transaction flow" - that sounds like a fancy term, but I don't really know what you mean by it - big old buzz word.