Re: Changing ROWID
From: Steve Edelstein <74160.645_at_CompuServe.COM>
Date: 6 Jan 1995 18:06:15 GMT
Message-ID: <3ek0qn$ern$1_at_mhadf.production.compuserve.com>
Date: 6 Jan 1995 18:06:15 GMT
Message-ID: <3ek0qn$ern$1_at_mhadf.production.compuserve.com>
An update only changes the rowid id the row is moved. If the update happens normally, and the updated data is too big to fit into the original block of the parent row (say adding a large chunk of data to the row), then Oracle will chain to another block to store the new data. The rowid shouldn't change at that point since the parent of the new data is in the same place.
-- Steve Edelstein VOICE: 212-956-3670 Relational Business Systems CompuServe: 74160,645 124 West 60th Street Suite 47C Author of New York, NY 10023 "Learning Oracle Forms"Received on Fri Jan 06 1995 - 19:06:15 CET