DBMS_AUDIT_MGMT.INIT_CLEANUP failed with "ORA-01403: no data found"
Hi,
DBMS_AUDIT_MGMT.INIT_CLEANUP failed with "ORA-01403: no data found".
SQL> BEGIN
IF DBMS_AUDIT_MGMT.IS_CLEANUP_INITIALIZED(DBMS_AUDIT_MGMT.AUDIT_TRAIL_ALL)
THEN
dbms_output.put_line('is initialized');
ELSE
dbms_output.put_line('is not initialized');
END IF;
END; 2 3 4 5 6 7 8
9 /
is not initialized
PL/SQL procedure successfully completed.
SQL> BEGIN
2 DBMS_AUDIT_MGMT.INIT_CLEANUP(
audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_ALL,
default_cleanup_interval => 24);
dbms_output.put_line('init cleanup for audit trail AUDIT_TRAIL_ALL is done.'); 3 4 5
6 END;
7 /
BEGIN
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "AUDSYS.DBMS_AUDIT_MGMT", line 2344