Re: Are rowids unique among tables?

By definition, a rowid identifies the storage location of a row within a datafile/extent/block. Since no two rows (from the same table or otherwise) can physically occupy the same space, rowids are unique through out a given database. I don't know why your last query didn't work though -- curious....

Pei Ku

In article <8rj4am$28m$1_at_nnrp1.deja.com>,   kal121_at_my-deja.com wrote:
> I know that rowids are unique within a given table, but are they
 unique
> among tables? I tried to verify this myself, but Oracle wouldn't let
 me.
>
> (works ok)
>
> SQL> select rowid from tab1;
>
> ROWID
> ------------------
> AAAA5bAAHAAAAFrAAA
> AAAA5bAAHAAAAFrAAB
>
> (does not work)
>
> SQL> select rowid from tab1 where rowid in (select rowid from tab2);
>
> select rowid from tab1 where rowid in (select rowid from tab2)
> *
> ERROR at line 1:
> ORA-01410: invalid ROWID
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 05 2000 - 19:27:50 CDT