Are rowids unique among tables?

From: <kal121_at_my-deja.com>
Date: Thu, 05 Oct 2000 23:53:59 GMT
Message-ID: <8rj4am$28m$1@nnrp1.deja.com>

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. Received on Thu Oct 05 2000 - 18:53:59 CDT