Re: Changing ROWID
Date: 6 Jan 1995 08:23:52 GMT
Message-ID: <3eiumo$3st_at_dcsun4.us.oracle.com>
In article <3eeuvt$8cg_at_newsbf02.news.aol.com> danielkm_at_aol.com (Daniel K M) writes:
>We recently had a small controversy around the office about when a ROWID
>will change for a given row. One camp held forth that ROWIDs were
>unreliable, and could possibly change even with a simple update. The
>other camp, pointing to an Oracle DBA manual, indicated that a ROWID
>remains constant "over the lifetime of the row". The second group
>believed that the "lifetime of a row" meant the time from when the row was
>created by an insert, until it was destroyed via a delete.
>Which is right?
The second group is right.
Note that the ROWID can change if you export and import the table or if you do anything else that eliminates that row and recreates an identical row. Received on Fri Jan 06 1995 - 09:23:52 CET