Re: changing ROWID

stuff deleted...
>>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

A rowid is related to one and only one table. For a table within a cluster it might appear that another table can have the same rowid but since different tables rowid cann't be compared in any way the above example makes no sense.

Jonathan Klein
Oracle Corporation
RDBMS Development - Manager, Data Management Received on Tue Jan 31 1995 - 09:25:24 CET