SQL> select file_id,tablespace_name,file_name,autoextensible from dba_data_files where tablespace_name like 'TEST_T%';
FILE_ID TABLESPACE_NAME FILE_NAME AUTOEX
---------- --------------- ---------------------------------------- ------
7 TEST_TAB /home/Oracle/oracle/oradata/mdsp/test_ta NO
b.dbf
SQL> alter database datafile '/home/oracle/oracle/oradata/mdsp/test_tab.dbf' autoextend on next 1 m;
Database altered.
SQL> select file_id,tablespace_name,file_name,autoextensible from dba_data_files where tablespace_name like 'TEST_T%';
FILE_ID TABLESPACE_NAME FILE_NAME AUTOEX
---------- --------------- ---------------------------------------- ------
7 TEST_TAB /home/oracle/oracle/oradata/mdsp/test_ta YES