Home » RDBMS Server » Server Utilities » sqlldr help needed
sqlldr help needed [message #406970] Mon, 08 June 2009 01:26 Go to next message
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 #406974 is a reply to message #406970] Mon, 08 June 2009 01:38 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Where is your control file?
Where is your table structure?

By
Vamsi
Re: sqlldr help needed [message #406983 is a reply to message #406974] Mon, 08 June 2009 01:59 Go to previous messageGo to next message
panyam
Messages: 146
Registered: May 2008
Senior Member
I got the solution ..

How ever thank's vamsi for your response.

[Updated on: Mon, 08 June 2009 01:59]

Report message to a moderator

Re: sqlldr help needed [message #406990 is a reply to message #406983] Mon, 08 June 2009 02:10 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Good!! Anyway, please post the solution.
It may helpful for others.

By
Vamsi
Re: sqlldr help needed [message #407074 is a reply to message #406990] Mon, 08 June 2009 06:29 Go to previous message
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')" )





Previous Topic: how to export statistics of table without table structure in oracle 9i
Next Topic: sql loader
Goto Forum:
  


Current Time: Thu Dec 08 06:00:51 CST 2016

Total time taken to generate the page: 0.09518 seconds