Difference between revisions of "Show files for a given tablespace"
From Peter Pap's Technowiki
| Line 3: | Line 3: | ||
column name format a20 | column name format a20 | ||
column filename format a50 | column filename format a50 | ||
| − | + | ||
select ts.name, df.name as FILENAME | select ts.name, df.name as FILENAME | ||
from V_$TABLESPACE ts, V_$DATAFILE df | from V_$TABLESPACE ts, V_$DATAFILE df | ||
where df.TS# = ts.TS# | where df.TS# = ts.TS# | ||
order by ts.name , df.name; | order by ts.name , df.name; | ||
Latest revision as of 00:43, 11 March 2021
set linesize 160 set wrap off column name format a20 column filename format a50 select ts.name, df.name as FILENAME from V_$TABLESPACE ts, V_$DATAFILE df where df.TS# = ts.TS# order by ts.name , df.name;
