G
gus bjorklund
Guest
yes, Klaus, a rowid/recid is constant for the "life of a record”. This means from the time it is created until it is deleted. in between those operations, it may be updated one or more times. This is by design so that the index entries (which contain the rowid) will not have to be updated. However, there are these exceptions: 0) in a partitioned table, if you change the value of the partitioning key, the row may be move dfrom one partition to another. if this happens, the rowid will change and index entries will be updated. 1) a tablemove will cause the rowid to change and the index entries to be updated. 2) If you dump and load a table, then the rowid will change because the original record will be deleted and a new one created in its stead. The table’s indexes will have to be rebuilt in this case. -gus
Continue reading...
Continue reading...