Database Utilities (MOSC)

MOSC Banner

How to fix "ORA-01852: seconds must be between 0 and 59" from sql loader?

edited Mar 22, 2019 9:00PM in Database Utilities (MOSC) 2 commentsAnswered ✓

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center