SQL LOADER -Ora error-01858 and 01843 [message #301824] |
Thu, 21 February 2008 20:39 |
mandys
Messages: 14 Registered: February 2008 Location: Pittsburgh
|
Junior Member |
|
|
Hi,
I am using SQL LOADER for the first time.I am trying to load data
from a CSV file.
This is my control file:
Load Data
Infile 'c:\stcity\stcity_1234.csv'
BADFILE 'c:\stcity\stcity.bad'
DISCARDFILE ''c:\stcity\stcity.discard'
APPEND
INTO TABLE
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(old_name,
old_address1,
old_address2,
old_id filler,
old_phone filler,
old_fax filler,(I dont need these field in my table)
sdate date(I tried using TO_DATE)
)
(I am getting ORA ERROR-01858 and ORA 01843 )A non-numeric character was found where numeric is expected.)
Thanks,
Mandy
|
|
|
|
|