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

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Fri, 08 Feb 2002 14:44:54 GMT
Message-ID: <GvR88.14473$Pz4.113090_at_rwcrnsc53>

As long as you don't do the following
insert a row like this:
primary_key text

1                  hi

then delete it then reinsert it
primary_key text

1                  hi

then the rowid of this item will not change. Oracle doesn't move rows around magically. The exception is an IOT (index organized table) where the row ids are different. That is because the table is ordered in a particular manner - index organized.

Jim
"Kasp" <kasp_at_epatra.com> wrote in message news: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:44:54 CET