Show files for a given tablespace: Difference between revisions
Jump to navigation
Jump to search
Created page with "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..." |
No edit summary |
||
| Line 1: | Line 1: | ||
set linesize 160 | set linesize 160 | ||
set wrap off | set wrap off | ||
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; | ||
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;