Oracle increases table space size by two methods

Table space is not sufficient to add a tablespace database file

Alter tablespace USERS add datafile '/oracle/app/oradata/shpog/user02.dbf ' size 16G autoextend on;

Alter tablespace SYSTEM add datafile '/oracle/app/oradata/shpog/undotbs01.dbf ' size 5G;

Table space is not sufficient to increase file size in the original file

ALTER DATABASE datafile '/ORACLE/APP/ORADATA/ORCL/SYSTEM01.DBF ' resize 5G;

ALTER DATABASE datafile '/ORACLE/APP/ORADATA/ORCL/SYSAUX01.DBF ' resize 5G;

This article from "system1987" blog, reproduced please contact the author!

Oracle increases table space size by two methods