How to check if tablespaces datafiles are autoextend
col FILE_NAME for a60 select TABLESPACE_NAME, FILE_NAME,AUTOEXTENSIBLE,MAXBYTES from dba_Data_files where TABLESPACE_NAME like 'Tablespace_Name'; _________________________________________________________________________________________________________________________ col FILE_NAME for a60 select TABLESPACE_NAME, FILE_NAME,AUTOEXTENSIBLE,MAXBYTES from dba_Data_files where TABLESPACE_NAME like 'UNDO%'; TABLESPACE_NAME FILE_NAME AUT MAXBYTES ------------ ------------------ ----------------------- ----- ------------------- UNDOTBS1 +DATA/ORACLEWORLDS/DATAFILES/undotbs1.2921 YES 3.4
Check the values in AUTOEXTENSIBLE column, if it’s YES means this feature is enabled on the file in column FILE_NAME like above example.