How to delete records older than 7 days from sys.aud$

delete from sys.aud$ where trunc(NTIMESTAMP# ) < trunc(sysdate - 7);

you can change the number 7 above to any number of days you like.

1 comment:

  1. Its true, but an good idea, counting records, befor run the delete command.

    ReplyDelete