Is this a good query to find segment where this block ( 259186 )  belongs ?

select  segment_name

from dba_extents

where block_id<= 259186 and 259186 <= block_id+blocks

 

 

-ak

 

Reply via email to