DBMS_ROWID.ROWID_BLOCK_NUMBER(RowID)
SQL> select DBMS_ROWID.ROWID_BLOCK_NUMBER(RowID) 2 from dual 3 where RowNum=1; DBMS_ROWID.ROWID_BLOCK_NUMBER(ROWID) ------------------------------------ 2082 SQL>