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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
sqlldr username/password@server control=upload.ctl
ASKER
So I just run the following command from sqlplus?
sqlldr username/password@myserver control=C:\upload.ctl
sqlldr username/password@myserver
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.