Re: Does the rowid get changed when the row is updated

From: Roger Snowden <snowden_at_NOT.com>
Date: Tue, 12 Jan 1999 04:36:20 GMT
Message-ID: <369AD053.3B76A1B9@NOT.com>

No, the rowid never changes, even with chaining and migration. A "stub" of the original row is at the location of the ubiquitous rowid, which is why chaining and migration are so bloody-awful expensive.

Roger Snowden
Sr. Systems Engineering Specialist
Oracle Corporation
rsnowden_at_NOTus.oracle.com <-- to reply, remove the obvious

David Spaisman wrote:
>
> Under Oracle 8.0.4, one of my developers asked me if the rowid is
> changed if the row is updated? If thee is chaining?
>
> Can anyone provie me with an answer?
>
> Thanks.
>
> DAvid Spaisman
Received on Mon Jan 11 1999 - 22:36:20 CST