Now my system tablespace is 8 GB and free space is 7 GB dba_free_space. When I try to resize the system tablepspace 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.
Dig Deeper on Oracle database administration
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.