Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011
    Posts
    1

    Unanswered: sql loader error 128

    i am uploading data through sqlloader .i am giving the following command.

    sqlldr sys as sysdba/abcd1234 control="data.ctl"

    when i execute this i ma getting the error unable to log in session.
    please help
    i am getting amd .as i have searched on the net .but hasnt got any answer for this

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >sqlldr sys as sysdba/abcd1234 control="data.ctl"
    the SYS schema should ONLY! be used to upgrade Oracle to newer version.
    SYS schema should NEVER be used in conjunction with application code or data.
    If you use a regular schema, the error will not occur.
    Besides the command line syntax is incorrect.
    in this case the "sqlldr" must be invoked while logged onto DB Server system itself
    in the future use COPY & PASTE so we can see exactly what you do & how Oracle responds
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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