Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ROWID Confusion

ROWID Confusion

From: Buck Turgidson <jcmanNOSPAM_at_worldnet.att.net>
Date: 2000/03/05
Message-ID: <l%ww4.4874$Pq3.354513@bgtnsc05-news.ops.worldnet.att.net>#1/1

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')


                                                    4
Received on Sun Mar 05 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US