If in your production database configured audit, DBA should maintain audit tables. Because audit records may grows up to undesired size. Today I will show you one of the easy way to care aud$ table. Scenario: Create new tablespace Create new archive table Create procedure Create Scheduler or Cron Job Execute and check result Firstly I will create new tablespace for my achived aud table. SQL> create tablespace arch_tbs datafile '/u01/app/oracle/oradata/ulfet_db/arch_tbs01.dbf' size 500M; Tablespace created. -- you can set more space SQL> alter tablespace arch_tbs add datafile '/u01/app/oracle/oradata/ulfet_db/arch_tbs02.dbf' size 500M; Tablespace altered. Now I will create new table with aud$ table structure but new table will be range partitioned. --You can create daily/monthly/yearly partition also subpartition too. To get table structure I use dbms_metadata.get_ddl package`s procedure. SQL> set pagesize 1000 SQL...