5 Replies Latest reply: Oct 9, 2012 5:41 AM by Paul M. RSS

    SQL*Loader: Error 500/09/54

      Hi I am getting the below error

      SQL*Loader: Release - Production on Mon Oct 8 19:27:31 2012

      Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

      SQL*Loader-500: Unable to open file (control.ctl"åX#åx%å)
      SQL*Loader-554: error opening file
      SQL*Loader-509: System error: The device does not recognize the command.

      Create table in my schema login as

      Create table mytable(Col1 smallint,Col2 smallint);


      Sqlldr userid=your userid/ password@database control=control.ctl

      control.ctl is saved in C: path and containts

      load data
      infile 'D:\Oracle\TestData.txt'
      into table Schema.mytable;
      fields terminated by "," optionally enclosed by '"'
      ( Col1,Col2);

      What is wrong with the above query.