Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2003
    Posts
    4

    Unanswered: Getting an error when using sqlldr

    All,

    I do the following - I have both my control and datafile in the same folder.

    $ sqlldr control

    control = lm_remedy_req.ctl.txt
    Password:

    SQL*Loader: Release 8.1.7.0.0 - Production on Mon Nov 3 10:01:26 2003

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    SQL*Loader-350: Syntax error at line 2.
    Expecting keyword LOAD, found "SQL".
    SQL*Loader: Release 8.1.7.0.0 - Production on Mon Nov 3 09:47:17 2003

  2. #2
    Join Date
    Oct 2003
    Location
    St.Louis,MO
    Posts
    120
    Could you post the contents of the control file?

    possibly a copy & paste issue where the SQL> prompt got left in the way?

  3. #3
    Join Date
    Nov 2003
    Posts
    4

    Re: Getting an error when using sqlldr

    Here is my control file if this helps.

    ----------------------------------------------------------
    --file name :tmlm_remedy_req.ctl
    --created by :Ashish Verma
    --date :21-Oct-2003
    --------------------------------------------------------
    --purpose to load data into the temp table from flat file

    LOAD DATA
    infile 'remedy_problem_ticket.txt'
    insert INTO TABLE tmlm_remedy_req_temp
    fields terminated by ',' optionally enclosed by '"' trailing nullcols
    (description char(4000),
    priority char(20),
    department char(40),
    application char(40),
    assignee char(20),
    problem char(4000),
    required_date,
    solution char(4000),
    bus_area_affected char(40))




    Originally posted by akverma
    All,

    I do the following - I have both my control and datafile in the same folder.

    $ sqlldr control

    control = lm_remedy_req.ctl.txt
    Password:

    SQL*Loader: Release 8.1.7.0.0 - Production on Mon Nov 3 10:01:26 2003

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    SQL*Loader-350: Syntax error at line 2.
    Expecting keyword LOAD, found "SQL".
    SQL*Loader: Release 8.1.7.0.0 - Production on Mon Nov 3 09:47:17 2003

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >$ sqlldr control
    How is SQLLDR supposed to know exactly what "control" is?
    It might work better is you do like the following:
    $ sqlldr control=control

  5. #5
    Join Date
    Nov 2003
    Posts
    4
    Thanks for the suggestion. I tried your rec and still got the following:

    $ sqlldr control=lm_remedy_req.ctl.txt
    Username:kintana
    Password:

    SQL*Loader: Release 8.1.7.0.0 - Production on Mon Nov 3 10:26:45 2003

    (c) Copyright 2000 Oracle Corporation. All rights reserved.

    SQL*Loader-350: Syntax error at line 2.
    Expecting keyword LOAD, found "SQL".
    SQL*Loader: Release 8.1.7.0.0 - Production on Mon Nov 3 09:47:17 2003


    any ideas?

  6. #6
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Try syntax like ...

    sqlldr.exe userid=username/password@service control=filename ...

    HTH
    Gregg

Posting Permissions

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