How To Move AUD$ and FGA_LOG$ to a Different Tablespace

The AUD$ and FGA_LOG$ tables used for audit recordings are in the SYSTEM tablespace by default. SYSTEM tablespace is a tablespace with manual segment space management. This causes problems with insertion into AUD$ table in 12c databases. It will also cause the SYSTEM table space to grow unnecessarily in heavily used databases.

It is recommended that these tables be moved to a different tableespace, which is segment space management auto.

You can view the current status with the following query.

You can create a new tablespace and move these two table to new tablespace.

Creating new table space

Moving the AUD$ table to new tablespace

Moving the FGA_LOG$  table to new tablespace

You can create a new tablespace and move these two table to new tablespace.

Creating new table space

Moving the AUD$ table to new tablespace

Moving the FGA_LOG$  table to new tablespace

You can create a new tablespace and move these two table to new tablespace.

Creating new table space

Moving the AUD$ table to new tablespace

Moving the FGA_LOG$  table to new tablespace

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *