oracle rowid detail

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博客 ” ，链接：http://blog.itpub.net/22936840/viewspace-749428/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22936840/viewspace-749428/