Database Security Products (MOSC)

MOSC Banner

Moving audit data to another tablespace

Hello,

By default, Oracle audit data (AUDIT_TRAIL_UNIFIED stored in the AUDSYS.AUD$UNIFIED table) is stored in the SYSAUX tablespace. According to the documentation, it is possible to specify another tablespace for storing this information using the SET_AUDIT_TRAIL_LOCATION command from the DBMS_AUDIT_MGMT package. However, based on my tests, this command must be run at a specific time. If this function is run later, it has no effect (the data is not moved).Is there a specific procedure for performing this move once auditing is enabled?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center