HOW TO INCREASE TABLESPACE SIZE IN ORACLE

BY ADDING DATAFILE:

alter tablespace <tablespace_name> add datafile '<location_for_datafile>' size 1g autoextend on next 100m maxsize 4g;

example:

alter tablespace TS1 add datafile '/u01/app/oracle/oradata/oradb/ts02.dbf' size 1g autoextend on next 100m maxsize 4g;

BY RESIZING DATAFILE:

alter database datafile 'location_for_datafile' resize 2g;

example:

alter database datafile '/u01/app/oracle/oradata/oradb/ts01.dbf' resize 2g;