| sqlldr help needed [message #406970] |
Mon, 08 June 2009 01:26  |
panyam
Messages: 146
Registered: May 2008
|
Senior Member |
|
|
Hi all,
From one of the unix scrip i am getting the data in the below format :
10001,"Scott Tiger", "12/05/2009"
10002,"Frank Naude", "13/05/2009"
I need to upload the above data to a table using SQLLDR:
now the problem is while inserting the last field value which is a date.
I am getting the error in the log file as :
Record 1: Rejected - Error on table SAMPLE, column K.
ORA-01858: a non-numeric character was found where a numeric was expected
how can i use "to_date" in this case ?..
|
|
|
|
|
|
|
|
|
|
| Re: sqlldr help needed [message #407074 is a reply to message #406990] |
Mon, 08 June 2009 06:29  |
panyam
Messages: 146
Registered: May 2008
|
Senior Member |
|
|
I changed the control file entry to handle this :
load data
infile 'D:\ravi.txt'
into table sample
fields terminated by "," optionally enclosed by '"'
(i , j, k "to_date(:k, 'DD/MM/YYYY')" )
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
