Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In today’s article, we will be learning how to make a Oracle AutoExtend Datafile on.
1. First, we must find a datafile that is not auto extent.
1 2 3 4 5 6 7 8 9 | SQL> select FILE_NAME, AUTOEXTENSIBLE from dba_data_files; FILE_NAME AUT ----------------------------------------------------------------------------------- +DATA/tapgg/datafile/users.259.856031463 YES +DATA/tapgg/datafile/undotbs1.258.856031463 YES +DATA/tapgg/datafile/sysaux.257.856031463 NO |
2. Then we make the datafile “AUTOEXTEND ON” as follows.
1 | SQL> ALTER DATABASE DATAFILE '+DATA/tapdb/datafile/users.276.869129771' AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED; |
