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...") |
|||
| (One intermediate revision by the same user not shown) | |||
| 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; |
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;
