Doc

Name: TS_DF.sql

Author: Mahnho Han

List all data files on a tablespace

#

SET VERIFY OFF

SET PAGESIZE 0

COMPUTE SUM of MB

select TABLESPACE_NAME,FILE_NAME,BYTES/1024/1024 MB

from DBA_DATA_FILES

where TABLESPACE_NAME = '&TABLESPACENAME'

order by FILE_NAME;