根据rowid查找所属的对象号、文件号、块号、行号-还是简单一点吧

select rowid,
       dbms_rowid.rowid_object(rowid) obj#,
       dbms_rowid.rowid_block_number(rowid) block#,
       dbms_rowid.rowid_relative_fno(rowid) file#,
       dbms_rowid.rowid_row_number(rowid) row#
  from scott.emp;

ROWID                    OBJ#     BLOCK#      FILE#       ROW#
------------------ ---------- ---------- ---------- ----------
AAAR3xAAEAAAACXAAA      73201        151          4          0
AAAR3xAAEAAAACXAAB      73201        151          4          1
AAAR3xAAEAAAACXAAC      73201        151          4          2
AAAR3xAAEAAAACXAAD      73201        151          4          3
AAAR3xAAEAAAACXAAE      73201        151          4          4
AAAR3xAAEAAAACXAAF      73201        151          4          5
AAAR3xAAEAAAACXAAG      73201        151          4          6
AAAR3xAAEAAAACXAAH      73201        151          4          7
AAAR3xAAEAAAACXAAI      73201        151          4          8
AAAR3xAAEAAAACXAAJ      73201        151          4          9
AAAR3xAAEAAAACXAAK      73201        151          4         10
AAAR3xAAEAAAACXAAL      73201        151          4         11
AAAR3xAAEAAAACXAAM      73201        151          4         12
AAAR3xAAEAAAACXAAN      73201        151          4         13

posted @ 2017-03-14 10:08  Oracle-fans  阅读(607)  评论(0)  编辑  收藏  举报