解析ROWID，通过ROWID查看一个表的对象号，文件号；

SQL> select rowid,t.* from scott.dept t;

ROWID                  DEPTNO DNAME          LOC
------------------ ---------- -------------- -------------
AAAPW1AALAAAAA1AAA         10 ACCOUNTING     NEW YORK
AAAPW1AALAAAAA1AAB         20 RESEARCH       DALLAS
AAAPW1AALAAAAA1AAC         30 SALES          CHICAGO
AAAPW1AALAAAAA1AAD         40 OPERATIONS     BOSTON


rowid格式如下：
AAAPW1--->数据对象编号
AAL--->文件编号
AAAAA1--->块编号
AAA---->行号


SQL> select rowid,substr(rowid,1,6) "object",
  2  substr(rowid,7,3) "file",
  3  substr(rowid,10,6) "block",
  4  substr(rowid,16,3) "row"
  5  from scott.dept;

ROWID              object fil block  row
------------------ ------ --- ------ ---
AAAPW1AALAAAAA1AAA AAAPW1 AAL AAAAA1 AAA
AAAPW1AALAAAAA1AAB AAAPW1 AAL AAAAA1 AAB
AAAPW1AALAAAAA1AAC AAAPW1 AAL AAAAA1 AAC
AAAPW1AALAAAAA1AAD AAAPW1 AAL AAAAA1 AAD

通过dbms_rowid包，可以直接得到具体的rowid包含信息
select dbms_rowid.rowid_object(rowid)   object_id,
dbms_rowid.rowid_relative_fno(rowid)  file_id,
dbms_rowid.rowid_block_number(rowid)  block_id,
dbms_rowid.rowid_row_number(rowid)  num
from scott.dept;

select dbms_rowid.rowid_object(rowid)   object_id,
dbms_rowid.rowid_relative_fno(rowid)  file_id,
dbms_rowid.rowid_block_number(rowid)  block_id,
dbms_rowid.rowid_row_number(rowid)  num
  5  from scott.dept;

 OBJECT_ID    FILE_ID   BLOCK_ID        NUM
---------- ---------- ---------- ----------
     62901         11         53          0
     62901         11         53          1
     62901         11         53          2
     62901         11         53          3

SQL> select OBJECT_NAME from  dba_objects
  2  where OBJECT_ID=62901;

OBJECT_NAME
--------------------------------------------------------------------------------
DEPT

SQL> select file_name from dba_data_files where file_id=11;

FILE_NAME
--------------------------------------------------------------------------------
/u01/app/oracle/Disk1/users01.dbf