Tablespace - Datafile

 

Tablespace - Datafile  details query

set lines 200

col FILE_NAME for a60

select FILE_NAME,TABLESPACE_NAME,bytes/1024/1024/1024 from DBA_DATA_FILES where TABLESPACE_NAME='<Tablespace_name>';

col FILE_NAME for a60

select FILE_NAME,TABLESPACE_NAME,BYTES/1024/1024/1024 "IN GB" from dba_temp_files where TABLESPACE_NAME='<Tablespace_name>';