Rowids....."never" change ??

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 - 13:44:13 CET