2 Replies Latest reply: Feb 1, 2013 5:31 AM by Fran RSS

    Loading Data using sqlldr

    dbthought
      Hi All,

      Please help me to load below data.

      I am using below command but not all inserting into TEST_TABLE (sqlldr userid=scott/tiger control=c:\output2.sql)

      LOAD DATA
      INFILE *
      APPEND
      INTO TABLE TEST_TABLE
      FIELDS TERMINATED BY WHITESPACE
      TRAILING NULLCOLS
      (tablename,part_num,tabletype)
      BEGINDATA


      PATROL_ORA_8 0     2

      PATROL_NT__3 14     2

      PATROL_UNI_5 13     2





      PATROL_VSM_204 10     2

      PATROL_VSM_142 154     1

      PATROL_UNI_1 0     2



      PATROL_ORA_10     0     2

      PATROL_UNI_2 1     2

      PATROL_ORA_8 1     2


      thanks in advance