如何根据DBA号来获取数据的对象信息

scb0814

一个对象的其中一个数据块的DBA号为382524589,那如何根据这个号码来获取到该对象的信息：

DBV-00201: Block, DBA 382524589, marked corrupt for invalid redo application SQL> select DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(382524589) from dual; DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(382524592) ------------------------------------------------ 797193 SQL> select DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE(382524589) from dual; DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE(382524592) ----------------------------------------------- 91 SQL> SELECT tablespace_name, segment_type, owner, segment_name 2 FROM dba_extents WHERE file_id = 91 and &BL between block_id AND block_id + blocks - 1; 3 Enter value for bl: 797193 old 3: WHERE file_id = 91 and &BL between block_id AND block_id + blocks - 1 new 3: WHERE file_id = 91 and 797193 between block_id AND block_id + blocks - 1 TABLESPACE_NAME ------------------------------ SEGMENT_TYPE ------------------------------------------------------ OWNER ------------------------------ SEGMENT_NAME -------------------------------------------------------------------------------- PSINDEX INDEX SYSADM PS_Z_PI_P2010M

主要是调用了DBMS_UTILITY 包的对象来进行转换。