从Data block address获得文件,块号

ORACLE DUMP文件中总是存在一些DBA字段.要从Data block address获得文件,块号有两种方式:

方法一.选转换为2进制,前10位为文个号,后顾22位为块号

如:0x0080006d = 0000 0000 1000 0000 0000 0000 0110 1101

文件号:2  块号:109

方法二.通过ORACEL提代的函数转换:

select DBMS_UTILITY.data_block_address_file(to_number('80006d','xxxxxx')), DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK(to_number('80006d','xxxxxx')) from dual;
 
DBMS_UTILITY.DATA_BLOCK_ADDRES DBMS_UTILITY.DATA_BLOCK_ADDRES
------------------------------ ------------------------------
                             2                            109