Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ROWID Confusion
The following query returns the same number for both relative and absolute file_no. I was expecting the first query to return 1, since it is in the first (and only) file of the tablespace. Can anyone clear up my confusion?
SQL> select dbms_rowid.rowid_relative_fno(rowid)
2 from emp where empno = '7839'
3 /
DBMS_ROWID.ROWID_RELATIVE_FNO(ROWID)
4
SQL>
SQL> select dbms_rowid.rowid_to_absolute_fno(rowid,'SCOTT','EMP')
2 from emp where empno = '7839'
3 /
DBMS_ROWID.ROWID_TO_ABSOLUTE_FNO(ROWID,'SCOTT','EMP')
4Received on Sun Mar 05 2000 - 00:00:00 CST
![]() |
![]() |