| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: objects in a datafile
> -----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.
 |
 |