If there is more than table in the file you will need the block number as well. Suppose you are reading block 23691 from file 297.
Select segment_name, owner from dba_extents where 23691 between block_id and block_id + blocks -1 and file_id = 297 ;
|
Results 1 to 7 of 7
Thread: Table name from file#Threaded View
|
Click Here to Expand Forum to Full Width |