Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Dublin, Ireland
    Posts
    1

    Unanswered: sqlldr append to tables

    Hi all,
    I am new this forum and have a query/problem with sqlldr.
    I am loading data from text files into tables which already are populated with data. The message I am getting is the table must be empty. Does anyone know how I can append data to tables using sqlldr

    Thanks in advance

    DF

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Here's an example .... use "APPEND"

    Load Data
    infile 'k:\clients\labette\phpadata\lab_1.dat'
    Append
    Into Table LOADER_RECS
    When ( (1) = 'F' )
    Trailing NULLCols
    ( Load_Date SYSDATE,
    state constant 'KS', -- Hardcoded
    Provider_Name Position (002:026) Char,
    Provider_Address_1 Position (027:051) Char,
    Provider_Address_2 Position (052:076) Char,
    Provider_City Position (077:101) Char,
    Provider_State Position (102:103) Char,
    Provider_Zip_Code Position (104:113) Char,
    Federal_Tax_Number Position (114:123) Char,
    Hospital_id Position (124:129) Char,
    Provider_Telephone_Number Position (130:139) Char)


    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
  •