Database Administration (MOSC)

MOSC Banner

dbms_audit_mgmt oracle 12.1.0.2

edited Oct 13, 2015 11:33AM in Database Administration (MOSC) 5 commentsAnswered

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:

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