Error report - ORA-01870: the intervals or datetimes are not mutually comparable
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);