根据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          0AAAR3xAAEAAAACXAAB      73201        151          4          1AAAR3xAAEAAAACXAAC      73201        151          4          2AAAR3xAAEAAAACXAAD      73201        151          4          3AAAR3xAAEAAAACXAAE      73201        151          4          4AAAR3xAAEAAAACXAAF      73201        151          4          5AAAR3xAAEAAAACXAAG      73201        151          4          6AAAR3xAAEAAAACXAAH      73201        151          4          7AAAR3xAAEAAAACXAAI      73201        151          4          8AAAR3xAAEAAAACXAAJ      73201        151          4          9AAAR3xAAEAAAACXAAK      73201        151          4         10AAAR3xAAEAAAACXAAL      73201        151          4         11AAAR3xAAEAAAACXAAM      73201        151          4         12AAAR3xAAEAAAACXAAN      73201        151          4         13

转载于:https://www.cnblogs.com/iyoume2008/p/6547033.html