the following is my practise based on warehose's rowid

select u.rowid from knta_users u where u.username='admin';

A-Z (0-25),a-z(26-51),0-9(52-61),+(62),/(63)

AAATDT---object_id 19*power(64,2)+3*64+19 =dbms_rowid.rowid_object(rowid)

(truncate and move will change id)

select * from user_objects o where o.object_name='KNTA_USERS';

AAG ---relative_fno relative file no 6=DBMS_ROWID.rowid_relative_fno (u.ROWID)

select * from dba_data_files df where df.relative_fno=6;

AAAA0p -----block no 52*64+41=DBMS_ROWID.rowid_block_number (u.ROWID)

select * from dba_extents where segment_name='KNTA_USERS';

AAH---ROW No 7=DBMS_ROWID.rowid_row_number (u.ROWID)

ITPub博客

oracle rowid detail