OraFAQ Forum: Server Utilities » Problem Loading Data into Table- Tow fields appended & Converted into DateTime

Home » RDBMS Server » Server Utilities » Problem Loading Data into Table- Tow fields appended & Converted into DateTime

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

Problem Loading Data into Table- Tow fields appended & Converted into DateTime [message #520057]

Thu, 18 August 2011 06:12

mani_jagtap
Messages: 7
Registered: May 2010
Location: glasgow

Junior Member

Hi,

Need help in SQLLoader.

I have an issue my source data file will send Data and time which are char field in two separate fields and my control file should put it in one column (DATE+TIME)

I have tried putting it in DATE_1 field using "TO_DATE (:DATE_1,'DDMMYYYY HHMISS')" but this didn't work and Date went into one column and time into other field(resulting shifting all data by one column in table)

I also tried putting data and time which are character fields in to different vchar field and then appended these two fields and convert to Data format as below but it did gave me SQL*Loader -930- Error parsing insert statement for column and ORA-00984 column not allowed here error.

DATE_1 "TO_DATE(VCHAR_24||VCHAR_25,'DDMMYYYY HHMISS')",

Please find attached control file and data file.

Thanks,
Manisha

Attachment: DESINT.csv.CTL
(Size: 2.81KB, Downloaded 1743 times)

Report message to a moderator

[Message index]

		Problem Loading Data into Table- Tow fields appended & Converted into DateTime By: mani_jagtap on Thu, 18 August 2011 06:12
		Re: Problem Loading Data into Table- Tow fields appended & Converted into DateTime By: Michel Cadot on Thu, 18 August 2011 06:44
		Re: Problem Loading Data into Table- Tow fields appended & Converted into DateTime By: mani_jagtap on Thu, 18 August 2011 07:22
		Re: Problem Loading Data into Table- Tow fields appended & Converted into DateTime By: Michel Cadot on Thu, 18 August 2011 07:36

Previous Topic:	problem in loading data into table
Next Topic:	import

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 16:54:06 CDT 2024