View source for Show files for a given tablespace

← Show files for a given tablespace

Jump to navigation Jump to search

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: Users.

You can view and copy the source of this 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;

Return to Show files for a given tablespace.

Retrieved from "https://peterpap.net/index.php/Show_files_for_a_given_tablespace"