oracle block phisical address to block#

maojinyu發表於2011-06-29

SQL> select DBMS_UTILITY.DATA_BLOCK_ADDRESS_FILE( TO_NUMBER(‘0300c7f8‘, ‘XXXXXXXX’) ) FILE#,
DBMS_UTILITY.DATA_BLOCK_ADDRESS_BLOCK( TO_NUMBER(‘0300c7f8‘, ‘XXXXXXXX’) ) BLOCK#
from dual;
2 3
FILE# BLOCK#
———- ———-
12 51192

[@more@]

function rowid_create(rowid_type IN number,
object_number IN number,
relative_fno IN number,
block_number IN number,
row_number IN number)
return rowid;

ORA-08103壞快

dd if=資料檔名 of=輸出檔名 bs=塊大小 skip=塊號

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9907339/viewspace-1051758/,如需轉載,請註明出處,否則將追究法律責任。

相關文章