-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|