Oracle Delete From a View


I need to compile below query:

delete from dba_audit_trail where TIMESTAMP > SYSDATE - 30;

Best Answer

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.