-
Sep24
利用ROWID准确定位数据所在的BLOCK
Posted in Database, 368 views
-
SQL>select rowid,
2 dbms_rowid.rowid_relative_fno(rowid) RFILE#,
3 dbms_rowid.rowid_block_number(rowid) BLOCK#,
4 dbms_rowid.rowid_row_number(rowid) ROW#,
5 t.*
6 from testabc t
7 /ROWID RFILE# BLOCK# ROW# BANNER
------------------ ---------- ---------- ---------- ----------------------------------------------------------------
AAADUUAAEAAAAAMAAA 4 12 0 Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
AAADUUAAEAAAAAMAAB 4 12 1 PL/SQL Release 10.2.0.4.0 - Production
AAADUUAAEAAAAAMAAC 4 12 2 CORE 10.2.0.4.0 Production
AAADUUAAEAAAAAMAAD 4 12 3 TNS for 32-bit Windows: Version 10.2.0.4.0 - Production
AAADUUAAEAAAAAMAAE 4 12 4 NLSRTL Version 10.2.0.4.0 - ProductionRelated posts:

Leave a comment | Trackback 这篇文章还没有评论.