Re: changing ROWID

From: Jonathan Lewis <Jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 27 Jan 1995 09:44:16 +0000
Message-ID: <791199856snz_at_jlcomp.demon.co.uk>

In article <3fjjli$ql8$1_at_mhadf.production.compuserve.com>

           74160.645_at_CompuServe.COM "Steve Edelstein" writes:

: Clarifying the post:
:
: 1. Two rows from different tables CANNOT share a rowid. Each
: rowid is a usique address for a single row of a single table.

Not quite ....

create cluster c1 (c1 varchar2(10));
create index c1i on cluster c1;
create table t1 (c1 varchar2(10)) cluster c1(c1); create table t2 (c1 varchar2(10)) cluster c1(c1);

insert into t1 values ('a');
insert into t2 values('a');

select rowid from t1;
ROWID

---

00000000003C.0000.0006

select rowid from t2;
ROWID

---

00000000003C.0000.0006

-- 
Jonathan Lewis

Received on Fri Jan 27 1995 - 10:44:16 CET