CODE EXAMPLE FOR SQL

oracle list datafiles in tablespace

SELECT * FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'tbs_name' ORDER BY FILE_NAME;