Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reclaim unused space in SYSTEM tablespace

SaicharanAMar 19 2019 — edited Mar 21 2019

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.

This post has been answered by Mark D Powell on Mar 19 2019

Jump to Answer

Added on Mar 19 2019

#11g, #general-database-discussions, #oracle

9 comments

2,126 views