> -----Original Message-----
> Sent: Thursday, 3 May 2001 10:45 PM
>
> what are the dictionary views required to find the objects in a
> particulr datafile.
Here's an example of a query that will show you all objects having at least one extent in a particular datafile.
select distinct a.owner, a.segment_name, a.partition_name, a.segment_type
from dba_extents a, dba_data_files b
where a.file_id = b.file_id
and b.file_name = '/u02/oradata/testsid/users01.dbf' ;
Of course, the objects may also have extents in other datafiles.
------
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com
