Difference between revisions of "Show files for a given tablespace"

From Peter Pap's Technowiki
Jump to: navigation, 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...")
 
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;