Database Administration (MOSC)

MOSC Banner

How to decrease the datafiles on SYSAUX tablespace after unified audit purge

edited Aug 12, 2020 12:49AM in Database Administration (MOSC) 7 commentsAnswered ✓

I'm running out of available space for the SYSAUX tablespace, few months back the SYSAUX tablespace kept running low on space an instead of finding the root cause a DBA team member kept adding more datafiles. The root cause was identified an fixed, then I had to purge 6 months of Unified audit logs. Now I'm left with 25 datafiles where I really only want to keep 2.

How can I accomplish this without having to move each schemas tables/indexes and Lobs seperately ?

Is it possible to Export SYSAUX tablespace, create a new SYSAUX2 tablespace import objects then drop/rename ?

Thanks for your attention.

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