Join the file_id as well as follows
select segment_name
from dba_extents
where file_id = 123
and 259186 between blocks and
blocks+block_id
HTH
Arup
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
Sent: Friday, March 14, 2003 11:03
AM
Title: Re: segment from block#
You also need to specify the file_id in the predicate. However, on anything
but a micky-mouse (T) database this query will take a long time which is
why I run a nightly job to populate a extent_to_object table which will
give me that answer quickly (except
You will need FILE_ID as well.
Here is what I use:
-- find_segment.sql
-- Finds segment name based on file_id and block_id
set Lines 132
col Owner for a10
col Segment_name for a30
col Segment_type for a20
col Tablespace_name for a30
select Owner,
Segment_Name,
Segment_Type,
