Hi,
how do I increase the size of the System Tablespace?
Thanks
Printable View
Hi,
how do I increase the size of the System Tablespace?
Thanks
ADD datafile...
But before that check if there are objects in SYSTEM tablespace owned by users other than SYS or SYSTEM
And if there are then try to relocate them, which will give you some free space in SYSTEM tablespace instead of immediately adding new datafile...
Sameer
Two options:
a) resize the current datafile(s) belonging to SYSTEM tablespace
ALTER DATABASE DATAFILE 'fileXYZ' RESIZE nnnn;
b) Add new datafile to SYSTEM tablespace
ALTER TABLESPACE system ADD DATAFILE 'fileXYZ' SIZE ....