My Oracle Support Banner

12.1 upgrade to 19c: DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION does not move AUD$UNIFIED table to a different tablespace (Doc ID 2816457.1)

Last updated on OCTOBER 22, 2021

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


After upgrading your Database from 12.1 to 19.11, you may find you cannot change your AUDIT_TRAIL to a new location.
The data continues to be written to the default SYSAUX.
In other words, the DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION does not work to change the default tablespace used for storing audit data.

This was working fine in but after upgrading, it no longer works.

You are also using Pure Unified Auditing.

You change the PARTITION_INTERVAL to 1 day for testing, but even after waiting several days (after the 30 day default time) this still fails to move.

Here are some steps to show / test this -->

1 - 12.1 DB
Create a tablespace called SYSTEM_UNIFIED_AUDIT and move / set the audit trail location to this user space:


5. Results
-- As you can see above the SYS_P1515 tab partition is still in SYSAUX.


 Upgrade from 12.1 to 19.x


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.