SQL>select rowid,
  2         dbms_rowid.rowid_relative_fno(rowid) RFILE#,
  3         dbms_rowid.rowid_block_number(rowid) BLOCK#,
  4         dbms_rowid.rowid_row_number(rowid) ROW#,
  5         t.*
  6    from testabc t
  7  /

ROWID                  RFILE#     BLOCK#       ROW# BANNER
------------------ ---------- ---------- ---------- ----------------------------------------------------------------
AAADUUAAEAAAAAMAAA          4         12          0 Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
AAADUUAAEAAAAAMAAB          4         12          1 PL/SQL Release 10.2.0.4.0 - Production
AAADUUAAEAAAAAMAAC          4         12          2 CORE        10.2.0.4.0      Production
AAADUUAAEAAAAAMAAD          4         12          3 TNS for 32-bit Windows: Version 10.2.0.4.0 - Production
AAADUUAAEAAAAAMAAE          4         12          4 NLSRTL Version 10.2.0.4.0 - Production

Related posts:

1. 打包安装oracle