CODE EXAMPLE FOR SQL

oracle tablespace autoextend

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