Database Administration (MOSC)

MOSC Banner

Error report - ORA-01870: the intervals or datetimes are not mutually comparable

edited May 27, 2020 5:38AM in Database Administration (MOSC) 8 commentsAnswered

Dear All,

During of a job creation I got  an error as follows:

BEGIN

    DBMS_SCHEDULER.CREATE_JOB (

            job_name => '"SYS"."PURGE_STD_AUDIT_TRAILS"',

            job_type => 'PLSQL_BLOCK',

            job_action => 'BEGIN

    DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP(

    audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_OS,

    last_archive_time => sysdate - 3,

    rac_instance_number => 1 );

    DBMS_AUDIT_MGMT.SET_LAST_ARCHIVE_TIMESTAMP(

    audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_OS,

    last_archive_time => sysdate - 3,

    rac_instance_number => 2 );

    DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(

    audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_OS,

    use_last_arch_timestamp => TRUE);

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