I need to compile below query:

delete from dba_audit_trail where TIMESTAMP > SYSDATE - 30;

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.


Not the answer you're looking for? Browse other questions tagged or ask your own question.