1 Reply Latest reply: Feb 22, 2013 5:12 AM by jeneesh RSS

    Sqlldr Issue v:oracle10g

    886282
      Hi I am trying to user sqlldr with my following code,

      sqlldr sqlplus username/password@server control='D:\Folder_name\loader.ctl'

      loader.ctl
      ----------------------------------
      load data
      infile 'sample.csv'
      into table_test
      fields terminated by "," skip 1 optionally enclosed by '"'          
      ( TABLE_NAME,ARCHIVE_COUNT,ARCHIVE_DATE
      )

      sample.csv
      ------------------------
      TABLE_NAME,COUNT,DATE
      ARCHIVE.ALLOC_ORDER_RELEASE_D_DMP,31083,4-Mar-11
      ARCHIVE.ALLOCATION_BASE_DMP,15287,4-Mar-11
      ARCHIVE.ALLOCATION_DMP,15840,4-Mar-11
      ARCHIVE.APPOINTMENT_DMP,1494,5-Mar-11
      ARCHIVE.APPOINTMENT_DMP,1774,3-Mar-11
      ARCHIVE.APPOINTMENT_DMP,2848,26-Feb-11

      table table_test
      --------------------------------
      TABLE_NAME     VARCHAR2(50 BYTE)
      ARCH_COUNT     VARCHAR2(50 BYTE)
      ARCH_DATE     VARCHAR2(50 BYTE)

      BUt I am getting the folling error..... Please help

      LRM-00112: multiple values not allowed for parameter 'control'

      SQL*Loader: Release 9.0.1.5.0 - Production on Fri Feb 22 16:35:18 2013

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

      SQL*Loader-100: Syntax error on command-line

      Thanks in Advance....
        • 1. Re: Sqlldr Issue v:oracle10g
          jeneesh
          883279 wrote:
          Hi I am trying to user sqlldr with my following code,

          sqlldr sqlplus username/password@server control='D:\Folder_name\loader.ctl'
          In your script, do you actually have the word "sqlplus" ?

          That is not required.. It should be
          sqlldr username/password@server control='D:\Folder_name\loader.ctl'