Link to home
Start Free TrialLog in
Avatar of mrong
mrong

asked on

Oracle SQL Loader

Hello,

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

Thanks in advance.
ASKER CERTIFIED SOLUTION
Avatar of Naveen Kumar
Naveen Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
sqlldr username/password@server control=upload.ctl
Avatar of mrong
mrong

ASKER

So I just run the following command from sqlplus?

sqlldr username/password@myserver control=C:\upload.ctl
Avatar of mrong

ASKER

where will be the log file after execution? thanks
log file will be there in the directory from where you are running the command "sqlldr username/password@myserver control=C:\upload.ctl "
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial