how do I increase the size of the System Tablespace?
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...
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 ....
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?