Two ways to increase the tablespace size in oracle

Increase the tablespace size: one is to add data files to the tablespace, and the other is to increase the size of the original data file in the tablespace. If you are interested, you may find it helpful.

Increase the tablespace size: one is to add data files to the tablespace. The other is to increase the size of the original data file in the tablespace. If you are interested, you may find it helpful.

Two Methods: one is to add data files to the tablespace:
The Code is as follows:
Alter tablespace users add datafile '/opt/oracle/oradata/esop/so_data02.dbf' size 200 M;

Another method is to increase the size of the original data file in the tablespace:
The Code is as follows:
Alter database datafile '/opt/oracle/oradata/esop/so_data01.dbf' resize 200 M;