CREATE TABLESPACE tablespace_name DATAFILE 'my_file.dbf' SIZE 30G AUTOEXTEND ON;
SELECT FILE_NAME, TABLESPACE_NAME, AUTOEXTENSIBLE FROM DBA_DATA_FILES WHERE AUTOEXTENSIBLE = 'YES' ORDER BY TABLESPACE_NAME, FILE_NAME;