Re: Changing ROWID
From: Jonathan Klein <jklein_at_thumper.oracle.com>
Date: 11 Jan 95 20:43:19
Message-ID: <JKLEIN.95Jan11204319_at_thumper.oracle.com>
Date: 11 Jan 95 20:43:19
Message-ID: <JKLEIN.95Jan11204319_at_thumper.oracle.com>
and the reason for this is that a rowid is related to a table and multiple tables containing rows stored on the same physical page could appear to have the 'same' rowid even though they are different values - a rowid is only meaningful in the context of a table (doesn't matter if the table is part of a cluster), not a cluster.
The SQL Language Reference manual (mine is 778-70-0292) makes one further point (pg 3-38 or see ROWID in the index):
"In most cases, a row's ROWID value uniquely identifies it in the database. However, in the case of clustered tables, rows in different tables can have the same ROWID."
Jonathan Klein
Oracle Corporation
RDBMS Development, Data Management
Received on Wed Jan 11 1995 - 20:43:19 CET