Database Security Products (MOSC)

MOSC Banner

ORA-46258: Cleanup not initialized for the audit , DBMS_AUDIT_MGMT.create_purge_job not working in

edited Apr 13, 2015 8:32AM in Database Security Products (MOSC) 1 commentAnswered ✓

CUSTOMER SAYS

we tried  the below package and getting errorand getting error

SQL> BEGIN

DBMS_AUDIT_MGMT.create_purge_job(

audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_FILES,

audit_trail_purge_interval => 1,

audit_trail_purge_name => 'PURGE_ALL_AUDIT_FILES',

use_last_arch_timestamp => TRUE);

END;

BEGIN

*

ERROR at line 1:

ORA-46252: Cannot complete the operation, overlapping job already exists

ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 177

ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 3677

ORA-06512: at "SYS.DBMS_AUDIT_MGMT", line 1245

ORA-06512: at line 2

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