Re: Rowids....."never" change ??

ROWIDs remain till u dont move ur tables. once u reorganize, import/export or do some sort of data exporting & re-importing, the ROWIDs will change.

to stick to an unique PK is the way !

kasp_at_epatra.com (Kasp) 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 - 21:37:46 CET