hi all ,
i have created dbms_audit_mgmt.CREATE_PURGE_JOB and then i decided to change interval , i dropped the job using dbms_scheduler.drop_job proceduer , when i try to create another purge job i get error ORA-46252: Cannot complete the operation, overlapping job already exists , when i try to drop the job using dbms_audit_mgmt.DROP_PURGE_JOB i get error ORA-27475: unknown job "SYS"."CLEAR_UNIFIED_UDIT_TRAIL_JOB"
when i query SELECT JOB_NAME FROM DBA_AUDIT_MGMT_CLEANUP_JOBS;
JOB_NAME
----------------------------------------------------------------------------------------------------
CLEAR_UNIFIED_UDIT_TRAIL_JOB
now how to fix this , i tried dbms_stats.gather_*_stats nothing changed
anyone has any idea?