5 Replies Latest reply on Sep 12, 2019 4:59 PM by 792311

    System Tablespace is full

    792311

      Oracle DB: 11.2..3.0

      RAC

      OS: RHEL 6.7

       

      Problem: System table space is almost full.  I need to truncate, Delete, or Purge rows from Audit Trail Table AUD$ by following Doc ID 73408.1

       

      That doc offers 3 choices

       

       

      1) To purge all the audit records from the audit trail run this command

       

      SQL> truncate table aud$;

       

      2)To delete rows from the audit trail related to a particular audited object run this command:

       

      SQL> DELETE FROM sys.aud$ WHERE obj$name='<object_name>';

       

       

      3) If the audit trail information must be archived, copy the relevant rows to another table, then truncate the aud$ table and finally you can optionally export the backup table(backup_aud$) to an OS file and then drop the backup table :



      SQL> CREATE TABLE backup_aud$ AS SELECT * from sys.aud$;

       

      SQL> truncate table aud$;

       

       

       

      This is a QA server, so I don't need to save any audit files. I am thinking about using option 1


      SQL> truncate table aud$;

      Would using option 1 cause any problem on my DB or tablespace? 

       

      Thanks for your help.