DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: need help again.......

  1. #1
    Join Date
    Jan 2001
    Posts
    59

    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.


  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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

  3. #3
    Join Date
    Jan 2001
    Posts
    59

    didn't work


    try it, didn't work. It still ask me for user name and password

  4. #4
    Join Date
    Aug 2000
    Posts
    163
    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.

  5. #5
    Join Date
    Aug 2000
    Posts
    163

    Wink

    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.

  6. #6
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    :) Jeff Hunter alias marist89

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    [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

  8. #8
    Join Date
    Jan 2001
    Posts
    59

    Thanks. It works now.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width