-
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
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
|