I need to compile below query:
delete from dba_audit_trail where TIMESTAMP > SYSDATE - 30;
-
Why do you have to delete records from the view and can't use the system tables? – Joe W Apr 29 '20 at 15:29
-
Why are they not comfortable for this operation? You are going to need to give a more clear reasoning why you can do something with the view but not the exact same thing with the source tables. – Joe W Apr 29 '20 at 16:02
-
5Does this answer your question? How To Delete Record From dba_audit_trail in Oracle 11gR2 – Joe W Apr 29 '20 at 19:26
-
I think DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL is the right way of doing this. – Wernfried Domscheit Apr 30 '20 at 6:50
Add a comment
|
You cannot. You need to have SYSDBA privilege on the database.
SYSDBA doest not allow to delete from DBA_AUDIT_TRAIL view but it allows to use DBMS_AUDIT_MGMT which is the right way to purge the audit trail.
