Done
A reader, March 16, 2020 - 12:10 pm UTC
Hi,
I have tried the above way also, but am getting through an error even...can u do with here a sample example.
March 17, 2020 - 10:15 am UTC
Can you provide a simple example showing exactly what you're doing and the error you're getting?
Did you investigate the rows in the error table?
A reader, March 17, 2020 - 5:58 am UTC
Clearly the rows that you want to load are not in the correct format. Check some rows or do a select distinct on the column in the question.
That should help in troubleshooting
Cheers!
Use VALIDATE_CONVERSION in the Source Table
Arnab, March 17, 2020 - 7:50 am UTC
If you are using Oracle 12c and above (not sure which Oracle version you are using ) then you can take help of the function VALIDATE_CONVERSION to filter out only those records which can be converted to a date and then load those records into the target table. Also the ones which are invalid can also be identified using this same function and processed according to the error handling strategy as per your wish.
VALIDATE_CONVERSION Link:-
https://livesql.oracle.com/apex/livesql/file/tutorial_EDVE861IMHO1W3Q654ES9EQQW.html
March 17, 2020 - 10:16 am UTC
They say 11g... but good idea for those on 12.2 or higher.