Re: Changing ROWID
Date: 10 Jan 1995 22:40:02 GMT
Message-ID: <3ev2c2$lni_at_dcsun4.us.oracle.com>
In article <3ek0qn$ern$1_at_mhadf.production.compuserve.com> Steve Edelstein <74160.645_at_CompuServe.COM> writes:
>An update only changes the rowid id the row is moved.
To the best of my knowlege, and update can not move a row. Therefore, an update never changes a rowid.
>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 Tue Jan 10 1995 - 23:40:02 CET