Evaluate

Can I resize the SYSTEM tablespace?

An Oracle user asks if they can resize the SYSTEM tablespace.

My system tablespace was increasing day by day. It has gone up to 8 GB. Then I truncated AUD$ table and disabled auditing because the system tablespace was increasing.

Now my system tablespace is 8 GB and free space is 7 GB dba_free_space. When I try to resize the system tablepspace...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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.

The SYSTEM tablespace is one of the few that you cannot reclaim space from. A rebuild of the database is required. This is why many move the SYS.AUD$ table to another tablespace before turning on auditing.

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.

This was last published in June 2008

Dig Deeper on Oracle database administration

All
Evaluate
Manage
Problem Solve

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

Related Resources

Dig Deeper on Oracle database administration

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.