OraFAQ Forum: Server Utilities » Loading date into table with sqlldr (merged)

Home » RDBMS Server » Server Utilities » Loading date into table with sqlldr (merged)

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

Loading date into table with sqlldr (merged) [message #385095]

Fri, 06 February 2009 07:27

rroooott
Messages: 11
Registered: February 2009

Junior Member

Hello, I am trying to load data into a table with sqlldr, but I can't load a 'date' field, I always have error, reported in the bad file. For varchar and integer I have no problem. Can someone help me please?

Thank you

Report message to a moderator

Loading date with sqlldr [message #385096 is a reply to message #385095]

Fri, 06 February 2009 07:28

rroooott
Messages: 11
Registered: February 2009

Junior Member

Hello, I am trying to load data into a table with sqlldr, but I can't load a 'date' field, I always have error, reported in the bad file.
Tha format of the date is ok, in fact in a normal query it is everything ok!

For varchar and integer I have no problem. Can someone help me please?

Thank you

Report message to a moderator

Re: Loading date into table with sqlldr (merged) [message #385102 is a reply to message #385095]

Fri, 06 February 2009 07:38

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Oracle� Database Utilities
Part II SQL*Loader
Chapter 9 Field List Reference
Section Datetime and Interval Datatypes

Regards
Michel

Report message to a moderator

Re: Loading date into table with sqlldr (merged) [message #385110 is a reply to message #385102]

Fri, 06 February 2009 07:56

rroooott
Messages: 11
Registered: February 2009

Junior Member

Ok... so:

in the sample set I have:

john, 12-Dic-1999

I did try to write, in the control file:

LOAD DATA

INFILE 'sample.txt'
APPEND
INTO TABLE xxxxx
FIELDS TERMINATED BY ","
(
name,
birth DATE "DD-Mon-YYYY"
)

But I still have problems!!

Report message to a moderator

Re: Loading date into table with sqlldr (merged) [message #385111 is a reply to message #385110]

Fri, 06 February 2009 07:58

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

But I still have problems!!

This will help us in anything to help you.

Regards
Michel

Report message to a moderator

Re: Loading date into table with sqlldr (merged) [message #385120 is a reply to message #385111]

Fri, 06 February 2009 08:21

rroooott
Messages: 11
Registered: February 2009

Junior Member

Ok, I did solve, it was so simple!

sample set:

'pppppp', 12-Dic-2008

control file:

LOAD DATA

INFILE 'sample.txt'

APPEND

INTO TABLE xxxxxxxx

FIELDS TERMINATED BY ","

(
nome,
birth
)

Report message to a moderator

Previous Topic:	wrap utility
Next Topic:	Command for sql*loader to merge columns' values into new column

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 20:26:01 CST 2024