Hi all, I am using SQL Loader to transfer data from a text file (variable length, tab delimited) onto a table. I have a date field in the table and the corresponding value in the text file is like "2002-04-01 00:00:00".
This is the format in my control file :

(Resrv_date DATE "YYYY-MM-DD HH24:MM:SS")

But, I get the error :
Record1 - Rejected - Error on table xxx, column RESRV_DATE. Field in data file exceeds maximum length.

But when I exp/imp the data or use SQL's DTS, all works fine. Any help is greatly appreciated.

Thanks,
Shiva.