Re: Rowids....."never" change ??
Date: Thu, 07 Feb 2002 13:05:17 GMT
Message-ID: <hYu88.6119$AV5.109012_at_rwcrnsc51.ops.asp.att.net>
Assuming you are not using IOT's (index organized tables) then don't delete
a row and reinsert it. That would change the id. Don't reorganize the
table (export import) that will change the rowid. You can't prevent Oracle
from changing the rowid, that is what it uses to find the row.
Jim
"Kasp" <kasp_at_epatra.com> wrote in message
news:3b04990d.0202070444.2f170555_at_posting.google.com...
> I had written a module to index data present in a table.
>
> In doing so, I used the "unique" ROWIDs to "label" the data of each
> row that I indexed. Later, I thought of using the ROWIDs to retrieve
> this data.
>
> Now, it appears that ROWIDs are not fixed or constant. They have a
> "half-life" !!
>
> If this is true, then the code which I have written is doomed. :-(
> I should have used some Primary keys instead !!
>
> Is this because of Oracles' optimization or the way it stores data in
> its database?? If so, is there some way in which I can stop this
> changing ROWIDs ??
>
> TIA.
> -Kasp
Received on Thu Feb 07 2002 - 14:05:17 CET