SQL Loader using Filler
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQL Loader using Filler

Hybrid View

  1. #1
    Join Date
    Dec 2000
    Posts
    46
    I am trying to use SQL*Loader's Filler Feature and running into some problems.

    My Control File looks like This :

    LOAD DATA
    INFILE 'gtst_header.dat'
    BADFILE 'gtst_header.bad'
    DISCARDFILE 'gtst_header.dis'

    APPEND
    INTO TABLE gtst_header
    FIELDS TERMINATED BY "~" OPTIONALLY ENCLOSED BY '"'
    TRAILING NULLCOLS
    (
    ID1 FILLER,
    ID ":ID1" ,
    CONTRACT_NUMBER ,
    AUTHORING_ORG_ID ,
    RESOLVED_UNTIL
    )

    I get an error trying to refer to ID1. The error that the log file show is :

    Record 1: Rejected - Error on table GTST_HEADER.
    ORA-01008: not all variables bound

    Any Ideas how to use filler????

    Thanks in Advance
    Girish

  2. #2
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    chk this dox.
    One cannot use POSTION(x:y) with delimited data. Luckily, from Oracle 8i one can specify FILLER columns. FILLER columns are used to skip columns/fields in the load file, ignoring fields that one does not want. Look at this example:
    LOAD DATA
    TRUNCATE INTO TABLE T1
    FIELDS TERMINATED BY ','
    ( field1,
    field2 FILLER,
    field3
    )

    Cheers!
    Cheers!
    OraKid.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width