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

From: John P. Higgins <jh33378_at_deere.com>
Date: Mon, 11 Jan 1999 20:13:23 -0600
Message-ID: <369AAFC3.94D3C607@deere.com>

The rowid never changes. Period.

However, if you delete the row and then re-insert the row, it may not get the same rowid. Note: a reorg does just this.

So did the rowid change? From the Oracle perspective, NO. An old row went away and a new row came in.

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 - 20:13:23 CST