This Blog is also nick named as Oracle Slate, where we can chalk our experiences with Oracle Databases and related products of Oracle. This blog is very simple to understand and relatively useful for all the budding Oracle Dba's, Beginner Dba's, Dba's Under-Construction and
Experienced Dba's...
Sunday, July 10, 2011
Show the files that comprise a tablespace
set lines 100
col file_name format a70
select file_name
, ceil(bytes / 1024 / 1024) "size MB"
from dba_data_files
where tablespace_name like '&TSNAME'
/
No comments:
Post a Comment