3 Replies Latest reply: May 13, 2012 9:30 PM by 934835 RSS

    Sql Loader error

    934835
      Hi,

      I'm trying to load data using sqlloader with .ctl and .txt file.
      I'm using below syntax, when i execute SQL Loader command it gives me

      error message:
      =========
      Unable to Open file (mydata.txt)
      file not found
      No Such file or Directory


      Control file
      =======
      LOAD DATA
      INFILE 'c:\Test\Testing\mydata.txt'
      INSERT INTO TABLE XXTKY_CHK_OMD
      --APPEND
      REPLACE
      FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
      TRAILING NULLCOLS
      (
      Noc_Height "Ltrim(Rtrim(:Noc_Height))",
      Noc_Width "Ltrim(Rtrim(:Noc_Width))",
      Noc_Depth "Ltrim(Rtrim(:Noc_Depth))",
      Noc_Size "Ltrim(Rtrim(:Noc_Size))"
      )

      Sql Loder Command used
      ================
      sqlldr userid=abc/****@tst control=file_name.ctl data=mydata.txt

      Thanks.