Alter auto extent on existing datafile in Oracle September 25, 2020 To alter the existing datafile in Oracle database, use below query. alter database datafile '/u01/app/oracle/oradata/XE/system.dbf' autoextend on maxsize unlimited; Read more