Show files for a given tablespace

From Peter Pap's Technowiki
Revision as of 00:43, 11 March 2021 by Ppapa (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
 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;