Database Administration (MOSC)

MOSC Banner

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

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