Evaluate

Can I resize the SYSTEM tablespace?

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

Published: 02 Jun 2008

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.

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.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

How to use the CREATE SESSION command to track Oracle database logins

Which backup strategy should I use for my Oracle 10g database?

Can I drop a deleted datafile without dropping the tablespace?

ORA-03297: file contains used data beyond requested RESIZE value

Please create a username to comment.

Where InfluxDB time series database is going

MariaDB X4 brings smart transactions to open source database

How data lineage tools boost data governance policies

5 ways enterprises adapt to the data scientist shortage

Storytelling using data makes information easy to digest

Data-driven storytelling makes data accessible

SAP S/4HANA migration: Critical advice for moving off ECC

New SAP leadership faces big challenges in 2020

SAP Data Hub opens predictive possibilities at Paul Hartmann

SQL Server database design best practices and tips for DBAs

SQL Server in Azure database choices and what they offer users

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

Don't ever put a non-Java LTS release into production

Public API strategy considerations for enterprise adoption

Ideas on how to hold a successful code hackathon

Organizations try to predict the effect of 5G infrastructure

Top infrastructure and operations technology myths of 2019

Improve efficiency with server energy consumption tools

4 popular content collaboration platforms to consider

AI can enhance content security with a bit of planning

Ex-SAP exec steers Episerver CMS toward digital experience market

Why mobile recruiting is the future

Top 7 HR trends for 2020 and beyond: The change decade

For insider threat programs, HR should provide checks and balances

Dig Deeper on Oracle database administration

How to use the CREATE SESSION command to track Oracle database logins

Which backup strategy should I use for my Oracle 10g database?

Can I drop a deleted datafile without dropping the tablespace?

ORA-03297: file contains used data beyond requested RESIZE value

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.