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
|
|
|