oracle Increase Table Space Size Two Implementation Methods

Two ways, one is to add data files to the table space:

 
alter tablespace users add datafile '/opt/oracle/oradata/esop/so_data02.dbf' size 200M; 

Another way is to increase the size of the tablespace's original data file:

 
alter database datafile '/opt/oracle/oradata/esop/so_data01.dbf' resize 200M;