Home » RDBMS Server » Server Utilities » Error while loading data using SQLLDR (10g Windows xp)
Error while loading data using SQLLDR [message #308244] Sat, 22 March 2008 13:55 Go to next message
ShridharV
Messages: 29
Registered: January 2008
Junior Member
Hi friends,

I am facing trouble while loading data into a table using sqlldr.

The control file is like this

OPTIONS ( ROWS=1000)
LOAD DATA
INFILE 'E:\test.txt'
APPEND
INTO TABLE "TEMP"
FIELDS TERMINATED BY ","
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(USER_ID , START_TIME DATE "MM/DD/YYYY HH24:MI:SS")

The contents of the test.txt file is this

user1,09/26/2007 4:53:33 PM
user2,10/22/2008 4:53:33 PM

When I try to load the data I am getting the following error

Record 1: Rejected - Error on table "TEMP", column START_TIME.
ORA-01830: date format picture ends before converting entire input string. Please let me know what is going wrong.
Re: Error while loading data using SQLLDR [message #308245 is a reply to message #308244] Sat, 22 March 2008 14:24 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, date format you used isn't compatible with data you are trying to load. "PM" suggests that you must use it in DATE format. Furthermore, it means that you have to remove HH24. So, you should try with
START_TIME DATE "MM/DD/YYYY HH:MI:SS PM"

[Updated on: Sat, 22 March 2008 14:24]

Report message to a moderator

Re: Error while loading data using SQLLDR [message #308247 is a reply to message #308245] Sat, 22 March 2008 15:25 Go to previous message
ShridharV
Messages: 29
Registered: January 2008
Junior Member
Many thanks. It worked. Thanks again.
Previous Topic: oradim not working
Next Topic: import in 10g
Goto Forum:
  


Current Time: Fri Dec 09 06:07:28 CST 2016

Total time taken to generate the page: 0.08972 seconds