Thanks for the question, Rhys.
Asked: June 06, 2006 - 7:20 pm UTC
Last updated: June 07, 2006 - 3:24 pm UTC
Version: 10.2.0
Viewed 10K+ times! This question is
You Asked
Tom,
Under what conditions will the rowid of a given record change? e.g. if in a partitioned table, I UPDATE a record such that it moves to another partition, does this imply that the rowid will change too?
Are there other situations where the rowid can change based on an UPDATE?
Best regards,
Rhys
and Tom said...
For this to happen, the table must "allow for row movment"
and it will happen when:
a) you update a partition key and the row moves partitions
b) shrink a table (10g new feature), since rows move from the bottom to the "top" of the table in anticipation of re-drawing the high water mark (we have to change their rowids)
c) flashback a table (10g new feature), since the flashback table command really issues a DELETE+INSERT to put the data back the way it was.
Of course the UROWID of a row in an IOT can change if you modify the key as well. But it isn't a "true" rowid.
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment