1、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 users.table;
1、通过file#,block#查询到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 users.table WHERE dbms_rowid.rowid_relative_fno(rowid)=97 and dbms_rowid.rowid_block_number(rowid)=138243;