Show files for a given tablespace - Revision history

Ppapa at 00:43, 11 March 2021

2021-03-11T00:43:54Z

Ppapa at 00:43, 11 March 2021

2021-03-11T00:43:43Z

Ppapa: 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..."

2021-03-11T00:43:25Z

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..."

New page

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;

@@ Line 3: / Line 3: @@
    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;