Printable View
hi,
I have these lines in a load.cmd file
SQLLDR CONTROL=C:\codes\bcp\oracle\load.ctl, LOG=bar.log, BAD=baz.bad, DATA=C:\codes\bcp\oracle\data.csv,
userid=system@RESEARCH/manager
pause
I don't understand why it always ask me for username and password everytime when I execute the .cmd file. This is not what I wated becasue I need to execute the command in my java code.
thg.
SQLLDR CONTROL=C:\codes\bcp\oracle\load.ctl, LOG=bar.log, BAD=baz.bad, DATA=C:\codes\bcp\oracle\data.csv,
userid=system/manager@RESEARCH
pause
try it, didn't work. It still ask me for user name and password
What Jeff proposed should've worked. I've done it hundreds of times. Are you sure you're entering correct username and password? Check your spelling.
Ops. It wasn't Jeff. It was Marist89. I confused him/her with Jeff Hunter for some reason.
Anyway..One thing I missed. Try typing your command without separating commas.
Example:
SQLLDR CONTROL=C:\codes\bcp\oracle\load.ctl LOG=bar.log BAD=baz.bad DATA=C:\codes\bcp\oracle\data.csv userid=system/manager@RESEARCH
Sometimes you need to specify sqlloader version, i.e. 73, 80, 8i, etc.
Example:
SQLLDR73 CONTROL=C:\codes\bcp\oracle\load.ctl LOG=bar.log BAD=baz.bad DATA=C:\codes\bcp\oracle\data.csv,
userid=system/manager@RESEARCH
This shoul work.
If it doesn't post your error message here. We'll figure it out.
:) Jeff Hunter alias marist89
We always get confused...Quote:
Originally posted by mary
Ops. It wasn't Jeff. It was Marist89. I confused him/her with Jeff Hunter for some reason.
Thanks. It works now.