While checking the free space from dba_free_space table, I can see that we have 130GB of free space in SYSTEM tablespace. This is due to in the past we enabled the database audit and DBA_AUDIT_TRAIL used system tablespace. Now we have truncated the audit table, however we are not able to resize the datafiles because of high water mark.
So now how we can reclaim the unused space in SYSTEM tablespace?
Also is it advisable to move objects under SYSTEM tablespace to other, then shrink SYSTEM tablespace , then move back to SYSTEM?
Database version:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
Thanks in advance.