You can indicate how much the file's size should rise and the maximum size it should extend to. SQL> change database datafile to '/u01/oracle/ica/icatbs01.dbf' auto expand ON next 5M max size 500M; You may also use the following command to create a datafile auto-extendable when building a new tablespace.