-
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
Jeff Hunter
-
didn't work
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
-
[QUOTE][i]Originally posted by mary [/i]
[B]Ops. It wasn't Jeff. It was Marist89. I confused him/her with Jeff Hunter for some reason.
[/B][/QUOTE]
We always get confused...
Jeff Hunter
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|