Skip to Main Content
  • Questions
  • Unified Audit Log Change Tablespace Location

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Tharmendran.

Asked: October 22, 2021 - 6:37 am UTC

Last updated: October 27, 2021 - 2:10 am UTC

Version: Oracle 19c

Viewed 100+ times

You Asked

Hi Tom,

Is that we can changed the unified audit log tablespace from SYSAUX to standalone tablespace(example: TBS_AUDIT) online without restart the database? If yes, is that will be any impact by doing so?

and Connor said...

Yes there is an API for that

begin
  dbms_audit_mgmt.set_audit_trail_location(
    audit_trail_type => dbms_audit_mgmt.audit_trail_unified,
    audit_trail_location_value => 'NEW_TSPACE');
end;


Make sure the tablespace is large enough to contain the existing audit otherwise the routine will report an error before starting

Rating

  (1 rating)

Comments

Performance impact

Tharmendran Sukumaran, October 26, 2021 - 6:52 am UTC

Hi Tom,
Thanks for the response. Is that while we changing the tablespace, the current audit logging can continue to log? If yes, is that will log into the new tablespace defined?
Connor McDonald
October 27, 2021 - 2:10 am UTC

That is my understanding, but I'd encourage you to test it before doing this in Production.

More to Explore

Security

All of the vital components for a secure database are covered in the Security guide.