Resize smallfile tablespace - ORA-01144 I have only 2% free on tablespace UNDOTBS1.
It consist from 2 datafiles.

When I launch 

alter database datafile '+DATADF/dbname/datafile/undotbs1.555.23454732' resize 32G;


I got :


  ORA-01144: File size (4194304 blocks) exceeds maximum of 4194303 blocks




How can I extend this tablespace?
You have two options.

Your current limit with smallfiles is 2G.  As you can see there the limit is 4194303 blocks, which is 4194303 x 512 byte block size = 2,147,483,136 bytes = 2G.


  Option 1:


Mount your file systems with the -largefiles option, which will allow you to create 32G and higher.


  Option 2:


You can only add 2G datafiles.

alter tablespace UNDOTBS1 add datafile 'path/filename' size 2G;


The -largefiles option has been the default for many years now, so there shouldn't be a problem for your unix admin to change this.