文档介绍：DBA never sleep-DBA,永不眠
Focus on Oracle Database, GodenGate and Unix
[置顶] All about rowid in Oracle Database 11g
分类: Oracle 11g OCP Certification 2013-10-28 13:14 263人阅读评论(1) 收藏举报
dbms_rowidrowidrowid_block_numberROWID_RELATIVE_FNOOracle database
SQL> select ,t.* from t;
ROWID                  DEPTNO DNAME          LOC
------------------ ---------- -------------- -------------
AAAPtpAAEAAAADbAAA         10 ACCOUNTING     NEW YORK
AAAPtpAAEAAAADbAAB         20 RESEARCH       DALLAS
AAAPtpAAEAAAADbAAC         30 SALES          CHICAGO
AAAPtpAAEAAAADbAAD         40 OPERATIONS     BOSTON
rowid(AAAPtpAAEAAAADbAAD)详解
AAAPtp  --object#
AAE     --file#
AAAADb  --block#
AAD     --row#
SQL> select rowid ,
  2  substr(rowid,1,6) "OBJECT#",
  3  substr(rowid,7,3) "FILE#",
  4  substr(rowid,10,6) "BLOCK#",
  5  substr(rowid,16,3) "ROW#"
  6  from ;
ROWID              OBJECT#                  FILE#       
BLOCK#                   ROW#
------------------ ------------------------ ------------ ------------------------ ------------
AAAPtpAAEAAAADbAAA AAAPtp                   AAE         
AAAADb                   AAA
AAAPtpAAEAAAADbAAB AAAPtp                   AAE         
AAAADb                   AAB
AAAPtpAAEAAAADbAAC AAAPtp                   AAE         
AAAADb                   AAC
AAAPtpAAEAA