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 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

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 12.1.0.2 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.








Changes

 Upgrade from 12.1 to 19.x

Cause

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
Symptoms
Changes
Cause
Solution
References


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