根据数据块和文件id查询所在表是啥

SELECT *
  FROM DBA_EXTENTS A
WHERE FILE_ID = &FILE_ID
   AND &BLOCK_ID BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1;
select   owner,
         table_name,
         column_name,
         segment_name,
         index_name
from     dba_lobs where segment_name='SYS_LOB0000088399C00014$$'

Leave a Reply