How to decrease the datafiles on SYSAUX tablespace after unified audit purge
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.