Re: reusability of rowid

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 ?
>
> What is the frequency of such events happening ? I need to update certain
> records using the rowid but the problem is that the rowid is extracted
> earlier and I am afraid that by the time I update the record, I may be
> updating the wrong record because that record may have already been deleted
> and replaced by another person.
>
> Thanxs for any help ...
>
> mars_at_hk.super.net
>

Hello,

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.

Regards,

M

-- 
-----------------------------------------------------------------------------
                                                    MarkB_at_aboy.demon.co.uk
Lyric Quiz of the Week: "Even Presidents have newspaper lovers.
                         Ministers go crawling under covers."