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>


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

Original text of this message