SQL Loader using Filler

[gram2000]

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

[balajiyes]

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!