Script To Check Tablespace Data File Location

Script To Check Tablespace Data  File Location


select FILE_NAME,sum(bytes/1024/1024/1024) from dba_data_files where TABLESPACE_NAME='UNDOTBS1' group by FILE_NAME;