Show files for a given tablespace
From Peter Pap's Technowiki
Revision as of 00:43, 11 March 2021 by Ppapa (talk | contribs) (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...")
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;
