View source for Show files for a given tablespace

From Peter Pap's Technowiki

← Show files for a given tablespace

Jump to: navigation, 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"

Navigation menu