Re: ROWID Confusion

In article <l%ww4.4874$Pq3.354513_at_bgtnsc05-news.ops.worldnet.att.net>,   "Buck Turgidson" <jcmanNOSPAM_at_worldnet.att.net> wrote:
> 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?
>

relative = absolute until you have lots (more the one thousand at least) of files in your database.

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

--
Thomas Kyte                              tkyte_at_us.oracle.com
Oracle Service Industries
http://osi.oracle.com/~tkyte/index.html
--
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.