oracle block phisical address to block#
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
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-600 [kdBlkCheckError] [file#] [block#] [code]ErrorBloC
- Script:Translate RDBA relative data block addressBloC
- oracle dump blockOracleBloC
- oracle block type!OracleBloC
- ORACLE BLOCK DUMPOracleBloC
- oracle hot blockOracleBloC
- Oracle Log Block SizeOracleBloC
- Oracle Find block in ASMOracleBloCASM
- oracle block 格式 (zt)OracleBloC
- Oracle Block Cleanouts 塊清除OracleBloC
- oracle壞塊Block CorruptionsOracleBloC
- Oracle資料塊blockOracleBloC
- Oracle BBED(block browse and editor)OracleBloC
- 使用BBED檢視資料檔案頭(block# 1)的簡單使用及查詢DBID/DB_NAME等資訊BloC
- Oracle (block clean out) oracle的塊清除OracleBloC
- 【BLOCK】Oracle 塊管理常用SQLBloCOracleSQL
- Oracle索引分裂(Index Block Split)Oracle索引IndexBloC
- 初識oracle block系列(一)OracleBloC
- oracle 的 BLOCK CHANGE TRACKINGOracleBloC
- Oracle Block Change Tracking功能OracleBloC
- oracle block的深入研究OracleBloC
- 物理備份是以block來區別邏輯備份的(os block或oracle block) ?BloCOracle
- (轉)oracle dump block格式說明OracleBloC
- Oracle Data block 的物理結構OracleBloC
- Oracle 的 data block研讀(二)OracleBloC
- oracle10g data block structureOracleBloCStruct
- oracle的塊 db_block_sizeOracleBloC
- 啟用oracle block change trackingOracleBloC
- oracle corrupt block壞塊處理OracleBloC
- oracle實驗記錄 (block cleanout)OracleBloC
- RMAN備份效率之-oracle block internal(block 內部結構分解)OracleBloC
- oracle block資料塊itl小記OracleBloC
- zt_Oracle RBA(Redo Byte Address) 說明Oracle
- 【BLOCK】Oracle壞塊處理命令參考BloCOracle
- Block Change Tracking (Oracle 塊修改跟蹤)BloCOracle
- DB_BLOCK_SIZE and DB_CACHE_SIZE in OracleBloCOracle
- oracle 塊延遲清除(delayed block cleanout) 理解OracleBloC
- oracle concept——data block,extent,segment-01OracleBloC