Home -> Usenet -> comp.databases.oracle -> Re: Rowids....."never" change ??

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

From: Kasp <kasp_at_epatra.com>
Date: 8 Feb 2002 06:30:36 -0800
Message-ID: <3b04990d.0202080630.4b741bba_at_posting.google.com> 







ALright, but what I wish to know is that,  assuming the table has many
Inserts/Deletes and Updates...but no "import/exports"...will the ROWID
of any row change over a period of time ??



What I thought was that due to the "fragmentations", in the way Oracle
stored its data, by frequent Deletes/Updates/Inserts...maybe Oracle
would re-arrange, so as to optimizem these rows,  which would then
change the ROWIDs ??



Is this true? If so, then what is the "half-life" of Rowids? Is this
change very frequent or not ??



-Kasp
Received on Fri Feb 08 2002 - 15:30:36 CET












Original text of this message