How to check if tablespaces are autoextend

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.

Leave a Reply

Your email address will not be published. Required fields are marked *