OraFAQ Forum: Server Utilities » Error while loading data using SQLLDR

Home » RDBMS Server » Server Utilities » Error while loading data using SQLLDR (10g Windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error while loading data using SQLLDR [message #308244]

Sat, 22 March 2008 13:55

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.

Report message to a moderator

Re: Error while loading data using SQLLDR [message #308245 is a reply to message #308244]

Sat, 22 March 2008 14:24

Littlefoot
Messages: 21809
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

ShridharV
Messages: 29
Registered: January 2008

Junior Member

Many thanks. It worked. Thanks again.

Report message to a moderator

Previous Topic:	oradim not working
Next Topic:	import in 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 04:59:29 CDT 2024