How to Alter Oracle SYSTEM Tablespace max_size

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.
kamkaroAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
You cannot set AUTO for segment_space_management for the system tablespace.

To change the size:
alter tablespace SYSTEM default STORAGE(maxsize unlimited);
0
 
kamkaroAuthor Commented:
Thanks for your quick reply.
0
All Courses

From novice to tech pro — start learning today.