Difference between revisions of "Show files for a given tablespace"
From Peter Pap's Technowiki
(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...") |
|||
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;