Hi,
I have an Oracle RDBMS 11g that makes use of the Standard Audit Trail.
I would like to keep the audit for 3 months from the date the cleansing runs, meaning that will have the Audit Trail for 3 months back from the date I look at it.
But I have read that there is a limitation of 999 hours to set the "clean up interval".
For cleasing I ise a scheduled program like:
BEGIN
DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_PROPERTY(
AUDIT_TRAIL_TYPE => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD,
AUDIT_TRAIL_PROPERTY => DBMS_AUDIT_MGMT.CLEAN_UP_INTERVAL,
AUDIT_TRAIL_PROPERTY_VALUE => 999);
END;
/
Can someone confirm if this is correct or not?
If yes, does this also apply to Oracle RDBMS 12c.
Thanks by advance.
Kind Regards