Can I resize the SYSTEM tablespace?
An Oracle user asks if they can resize the SYSTEM tablespace.
Now my system tablespace is 8 GB and free space is 7 GB dba_free_space. When I try to resize the system tablepspace...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
datafile by altering the database datafile resize, I receive the error :ORA 03297 file contains used data beyond resize value. Can you help me to resize the system tablespace? Critical production database is 350 GB.
To be honest, I wouldn't worry about the extra space. As the saying goes today, "disk is cheap." And your system tablespace is less than 3% of your total database size. I would probably just leave things alone until I had a better reason to rebuild the database.