Re: Strange ROWID problem

From: Tommy Wareing <p0070621_at_brookes.ac.uk>
Date: Thu, 06 Aug 1998 10:26:12 GMT
Message-ID: <35c9846c.3055693@news.brookes.ac.uk>

On Wed, 05 Aug 1998 21:38:11 -0700, EXE <exe_at_exesolutions.com> wrote:

>> I have a dbout about using rowids to delete duplicate records. Please
>> clarify this:
>>
>> When there is lot of data in the tables, and you use rowids to delete rows,
>> what happens if Oracle decides to rearrange the data ?
>
>Rowid's are fixed to the row. They do not change as you insert, update, and
>delete. Row numbers are what change. The rowid is the fastest and most efficient
>way to identify a specific row.

With the proviso that delete frees up a ROWID, and insert uses a free ROWID.
Therefore deleting and reinsert a record may result in a different rowid for the same data, or the same rowid for different data.

--
Tommy Wareing
MIS Group
Learning Resources
Oxford Brookes University
01865 483389 Received on Thu Aug 06 1998 - 05:26:12 CDT