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 ....
Jurij Modic ASCII a stupid question, get a stupid ANSI 24 hours in a day .... 24 beer in a case .... coincidence?
Forum Rules