Re: changing ROWID

In <791199856snz_at_jlcomp.demon.co.uk> Jonathan_at_jlcomp.demon.co.uk (Jonathan Lewis) writes:

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

This can ONLY happen within a CLUSTER table, as a general rule two rows can NEVER share the same rowid. Received on Sat Jan 28 1995 - 03:43:19 CET