Here is my control file :
LOAD DATA
INFILE '1.txt'
INSERT INTO TABLE test_bam_util
TRUNCATE
REENABLE DISABLED_CONSTRAINTS
FIELDS TERMINATED BY '\t'
TRAILING NULLCOLS
(resrv_date DATE "YYYY-MM-DD HH24:MM:SS",
router CHAR,
if_name CHAR,
dummy1 FILLER,
dummy2 FILLER,
inbitssec CHAR)

If I use FIELDS TERMINATED BY WHITESPACE instead of '\t', I am able to get the data into the table, but the date data "2002-04-01 00:00:00" gets spilt into 2 seperate fields - "2002-04-01" and "00:00:00" - because of the space and hence in my table, the values I have are like :
resrv_date = "2002-04-01 00:00:00"
router = "00:00:00"

When I used the TO_DATE() functionality here, as in
resrv_date DATE "TO_DATE(:resrv_date,'YYYY-MM-DD HH24:MI:SS')", this is the error I get :
ORA-01821: date format not recognized

Any ideas/suggestions ??

Thanks,
Shiva.

[Edited by Shiva on 05-08-2002 at 12:56 PM]