Re: Will ROWID change during DB Runing??

nntp.lucent.com wrote:

> Hi,
>
> Does anyone know that whether the rowid will change for one record during
> ORACLE runing?
>
> From the below link
> http://www.adp-gmbh.ch/ora/concepts/rowid.html
> I found such words:
> Although a rowid uniquely identifies a row in a table, it might change its
> value if the underlying table is an index organized table or a partitioned
> table.
>
> Thanks in advance!
> Best Regards,
> Grant

ROWID can change and should not be used to identify a row unless that row has been locked: SELECT ... FOR UPDATE.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)