Home » RDBMS Server » Server Utilities » Problem Loading Data into Table- Tow fields appended & Converted into DateTime
Problem Loading Data into Table- Tow fields appended & Converted into DateTime [message #520057] Thu, 18 August 2011 06:12 Go to previous message
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
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: problem in loading data into table
Next Topic: import
Goto Forum:
  


Current Time: Thu Dec 05 16:27:59 CST 2019