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...") |
(No difference)
|
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;
