Rowids....."never" change ??
From: Kasp <kasp_at_epatra.com>
Date: 7 Feb 2002 04:44:13 -0800
Message-ID: <3b04990d.0202070444.2f170555_at_posting.google.com>
Date: 7 Feb 2002 04:44:13 -0800
Message-ID: <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 - 13:44:13 CET