Re: segment from block#

[Arup Nanda]

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 Subject: segment from block# 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