ORA-01873 the leading precision of the interval is too small

Hi

sorry for the first post

this message appears on 19.14.0.0 querying the ALL_JOBS table

ORA-01873 the leading precision of the interval is too small 

solution was this query without the TOTAL_TIME column

select JOB, LOG_USER, PRIV_USER, SCHEMA_USER, LAST_DATE, LAST_SEC, THIS_DATE, THIS_SEC, NEXT_DATE, NEXT_SEC, BROKEN, INTERVAL, FAILURES, WHAT, NLS_ENV, MISC_ENV, INSTANCE  

from ALL_JOBS

Kind regards,

Vincent P.

ORA-01873 the leading precision of the interval is too small

PS: sorry Mark I have edited my question during your answer ;-)