Answers for "oracle create tablespace autoextend with increment datafile name"

oracle create tablespace autoextend

CREATE TABLESPACE tablespace_name DATAFILE 'my_file.dbf' SIZE 30G AUTOEXTEND ON;

oracle tablespace autoextend

SELECT FILE_NAME, TABLESPACE_NAME, AUTOEXTENSIBLE
FROM DBA_DATA_FILES WHERE AUTOEXTENSIBLE = 'YES'
ORDER BY TABLESPACE_NAME, FILE_NAME;