Truncate sys.aud$ table

How to reclaim space from system
Solution

Step 1. Check to see what is the lagest table in the system tablespace

SELECT *
 FROM (  SELECT OWNER, SEGMENT_NAME, BYTES / 1024 / 1024 MB
           FROM DBA_SEGMENTS
          WHERE SEGMENT_TYPE = 'TABLE'
       ORDER BY BYTES / 1024 / 1024 DESC)
WHERE ROWNUM <= 10;

Step 2. If the largest tablespace is sys.aud$ then truncate the table.

TRUNCATE TABLE sys.aud$;

Applies to:
Oracle 11g and later- Information in this document applies to any platform.