dbms_audit_mgmt oracle 12.1.0.2
Hello,
I am trying to purge the audit trail using the following package and all of these works on oracle 11 but it fails on oracle 12.1.0.2 on some servers. Would this statement fail on newly created database. Has someone seen this problem before? Thanks.
set serveroutput on;
BEGIN
sys.DBMS_AUDIT_MGMT.deinit_cleanup(sys.DBMS_AUDIT_MGMT.AUDIT_TRAIL_ALL);
sys.DBMS_AUDIT_MGMT.init_cleanup(sys.DBMS_AUDIT_MGMT.AUDIT_TRAIL_ALL,24);
sys.DBMS_AUDIT_MGMT.set_last_archive_timestamp(sys.DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,SYSTIMESTAMP-365);
dbms_output.put_line('Done...');
END;
/
ERROR at line 1: