To resize a data file, use the ALTER DATABASE RESIZE DATAFILE command. Bigfile tablespace is an exception. You may use the ALTER TABLESPACE XXX RESIZE DATAFILE syntax with Oracle. Adding a data file to a big file tablespace is not permitted.