Newbie control file question
From: Sashi <smalladi_at_gmail.com>
Date: Tue, 1 Sep 2009 08:46:41 -0700 (PDT)
Message-ID: <883aac5e-e0b4-45ba-871d-140e7a4d5cfe_at_r27g2000vbn.googlegroups.com>
All, I'm trying to load data using a control file. Here's the sqlldr version:
SQL*Loader: Release 10.2.0.3.0 - Production on Tue Sep 1 11:43:14 2009
Date: Tue, 1 Sep 2009 08:46:41 -0700 (PDT)
Message-ID: <883aac5e-e0b4-45ba-871d-140e7a4d5cfe_at_r27g2000vbn.googlegroups.com>
All, I'm trying to load data using a control file. Here's the sqlldr version:
SQL*Loader: Release 10.2.0.3.0 - Production on Tue Sep 1 11:43:14 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Here's a sample data line:
"941 -
Warren","06/08/09","00:08","9085635152","9733928015","4","54","002","NEWARK ,
NJ","NJ","Toll",".18","0000019619"
Here's my control file:
LOAD DATA
INFILE '/my/source/file.csv'
INTO TABLE dest_table
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(
SWITCH_NAME,
CONNECT_DATE "MM/DD/YY",
CONNECT_TIME,
SRC_NUMBER,
DEST_NUMBER,
DUR_MM,
DUR_SS,
TRUNK,
LOCATION,
STATE,
CALL_TYPE,
COST,
EXP_CODE
)
It's being rejected thus:
Record 1: Rejected - Error on table CDR_TEMP_FEED, column
CONNECT_DATE.
How do I fix this?
TIA,
Sashi
Received on Tue Sep 01 2009 - 10:46:41 CDT