Oracle SQL Loader

Posted on 2013-09-05
Medium Priority
Last Modified: 2013-09-05

I have a upload.ctl and a data.txt file. How to use sql uploader to upload the data into Oracle?

Thanks in advance.
Question by:mrong
LVL 28

Accepted Solution

Naveen Kumar earned 1200 total points
ID: 39466753
browse through these links :


If you need help regarding any particular issue with the sql loader, then please be specific.

From the question, all i can say is run the sqlloader with the control file/data file by specifying them in the options.
LVL 28

Expert Comment

by:Naveen Kumar
ID: 39466757
sqlldr username/password@server control=upload.ctl

Author Comment

ID: 39466786
So I just run the following command from sqlplus?

sqlldr username/password@myserver control=C:\upload.ctl
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions


Author Comment

ID: 39466787
where will be the log file after execution? thanks
LVL 28

Expert Comment

by:Naveen Kumar
ID: 39466825
log file will be there in the directory from where you are running the command "sqlldr username/password@myserver control=C:\upload.ctl "
LVL 78

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 400 total points
ID: 39466847
>>So I just run the following command from sqlplus?

sqlldr is an OS command not a sqlplus command.  You run it from the command prompt.
LVL 14

Assisted Solution

by:Alexander Eßer [Alex140181]
Alexander Eßer [Alex140181] earned 400 total points
ID: 39466868
If the data file is not specified in the control file, you'll have to tell sqlldr via parameter/option:

sqlldr username/password@myserver control=upload.ctl data=data.txt

Open in new window


Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question