Solved

How to Alter Oracle SYSTEM Tablespace max_size

Posted on 2013-06-12
4
797 Views
Last Modified: 2014-01-13
Hi Experts,
I am not DBA that's why please help me.

When I executed the following command, I am getting (NULL) value on MAX_SIZE for SYSTEM (Tablepace_name) and Manual entry on Segment_space_management column.

Could you please help me how to increase the Max_size for system and change Auto for Segment_space_management columns.


"Select * from DBA_TABLESPACE;

This is my SYSTEM DATAFILE  D:\ORACLE\ORADATA\CISDW\SYSTEM01.DBF

Thanks.
0
Comment
Question by:kamkaro
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39241731
You cannot set AUTO for segment_space_management for the system tablespace.

To change the size:
alter tablespace SYSTEM default STORAGE(maxsize unlimited);
0
 

Author Comment

by:kamkaro
ID: 39241752
Thanks for your quick reply.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to Comment Out Lines of Code in a Pass Through Query In MS Access 2016 19 101
scheduler notification 9 80
Oracle Mulit-site configuration 28 73
Oracle Join issue. 3 48
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question