Re: how to find out table names from the given datafile???

From: <nomorekiss_at_yahoo.com>
Date: 28 Jan 2005 07:05:54 -0800
Message-ID: <1106921697.054382.173760@z14g2000cwz.googlegroups.com>

select d.name datafile_name,t.NAME tablespace_name,s.segment_name from v$datafile d,
v$tablespace t,
dba_segments s

where d.TS#=t.TS#
and   s.tablespace_name = t.NAME
and   s.segment_type = 'TABLE'
and   t.NAME = 'TABLESPACE1'

-- and s.owner = 'YOUR_SCHEMA_OWNER' Received on Fri Jan 28 2005 - 09:05:54 CST