Re: Changing ROWID

I just noticed this. I think I'm the person Daniel was referring to.

Um, Daniel, if you just say "you" in your post, how is the person you are talking to supposed to know that you are referring to him?

In article <D258xA.KIF_at_dorsai.org> gkirsh_at_dorsai.org (Gary Kirsh) writes:
>Daniel K M (danielkm_at_aol.com) wrote:
 

>: I notice from your address that you are at Oracle.
>: It might interest you to know that *every* other response was A) from
>: non-Oracle
>: personell and B) disagreed with you. This either indicates a massive
>: misunderstanding in the community about the nature of the ROWID, or it
>: means that you are mistaken. Can you back up your claim about ROWID being
>: safe for the "lifetime of the row". Are there any resources at Oracle I
>: can use
>: to resolve this question?

Certainly. Call technical support at 415 506 1500.

>As an ex-Oracle employee (6+ years) I felt compelled defend the Oracle person
>who said that the ROWID doesn't change. This is true with one exception -
>if the table is exported and imported the ROWID will likely change.
>Otherwise, it will stay the same until the row is deleted.

This is exactly what I said.

Actually, I will add two additional caveats:

1. If your table is a snapshot and the snapshot is refreshed the rowid may change.
2. I'm not sure what happens if you restore your database from a backup.