Oracle Datafile Autoextend On

Onur ARDAHANLI

8 months ago

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.

	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

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.

SQL> ALTER DATABASE DATAFILE '+DATA/tapdb/datafile/users.276.869129771' AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;

1	SQL> ALTER DATABASE DATAFILE '+DATA/tapdb/datafile/users.276.869129771' AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED;