Re: reusability of rowid

In article <773007303snz_at_aboy.demon.co.uk> MarkB_at_aboy.demon.co.uk writes:
>In article <2uph2q$35m_at_hk.super.net>
> mars_at_hk.super.net "Baby Mars All Alone in Hong Kong" writes:
>
>> hi ...
>>
>> Is it true that if a particular record is deleted, oracle will reuse
>> the rowid of that record for subsequent insertions of new records ?
>>
>
>It is an article of faith that a row can be uniquely identified, yes? So,
>whatever it is that allows you to know the rowid of the row that you
>wish to manipulate, is the whatever-it-is that you should use to identify it
>when manipulating it.
>
>If this is not the case, then either your database was designed by
>someone with the relational sense of a goldfish on speed (ie you are
>working on Financials), or you have come up with a problem that I
>would love to know more about.
>

I believe that the first response was slightly incomplete. I am not sure, but I think that Oracle does in fact reuse rowids; however, unless your program closes its connection to the database then re-connects, Oracle will know that the orignal record has been "messed" with and will inform you that you have a dirty buffer and will not allow you to update.

If this is critical, I suggest you contact Oracle directly and ask them.

-- 
============================================================================
Michael Sallwasser  | Down one path is utter dispair and hopelessness. Down 
Northrop Grumman    | the other is total destruction. Let us choose wisely.