'How do I truncate the Oracle audit table in AWS RDS?

How do I truncate the Oracle audit table in Amazon AWS RDS?

SQL> select count(*) from sys.aud$;

  COUNT(*)
----------
      1358

SQL> truncate table sys.aud$;
truncate table sys.aud$
                   *
ERROR at line 1:
ORA-01031: insufficient privileges


Solution 1:[1]

Connect as the admin user and run this rdsadmin command:

SQL> exec rdsadmin.rdsadmin_master_util.truncate_sys_aud_table;

PL/SQL procedure successfully completed.

SQL> select count(*) from sys.aud$;

  COUNT(*)
----------
         0

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Brian Fitzgerald