How to fix "ORA-01852: seconds must be between 0 and 59" from sql loader?
Hello,
I desperately need your help on fixing or suggest a work around for the "ORA-01852: seconds must be between 0 and 59" error I received from running sql loader in trying to store data from a csv file to an Oracle dB(10.1g) table.
The control card file is as following:
{
options (skip=1)
load data infile '$HOME/irismrs/HRM/SAMPLE/DOTMRS.IRISHRM.SAMPLE.csv' discardfile 'HRM.dsc'
replace
PRESERVE BLANKS
into table DOTPF_IRIS_STAFF_SAMPLE
fields terminated by ',' optionally enclosed by '"' trailing nullcols
(
EE_EMPLOYEE_ID,
PS_POSITION_ID,
EE_EMPLOYEE_LAST_NAME,
EE_EMPLOYEE_FIRST_NAME,