Problem with "systimestamp" and CSV file
678357Jan 6 2009 — edited Jan 8 2009Hi,
I try to insert some datas from a CSV file. One of columns of my table must be feed with the oracle system date and this column is in timestamp format.
So here is the syntax of my control file :
LOAD DATA
INFILE '__FICHIER_PLAT__'
APPEND INTO TABLE CLIENTS
FIELDS TERMINATED BY ';'
(
DATE_CREATION "systimestamp",
filler1 FILLER,
CODE_CLIENT "TRIM (:CODE_CLIENT)",
TYPE_CLIENT "TRIM (:TYPE_CLIENT)",
filler2 FILLER,
DATE_DEBUT "TO_DATE (:DATE_DEBUT,'YYYYMMDD')",
DATE_RESILIATIO "TO_DATE (:DATE_RESILIATIO,'YYYYMMDD')",
filler3 FILLER,
filler4 FILLER,
filler5 FILLER,
[...]
filler78 FILLER,
filler79 FILLER,
filler80 FILLER,
filler81 FILLER
)
I obtain this error :
Record 1: Rejected - Error on table CLIENTS, column FILLER81.
Column not found before end of logical record (use TRAILING NULLCOLS)
It seems SQL*Loader consider DATE_CREATION "systimestamp" as a field of my CSV file.
Do you know a syntax that allow to set a column with systimestamp ?
Thanks !