Re: Will ROWID change during DB Runing??

From: Grant Zhou <grantzhou_at_gmail.com>
Date: Fri, 31 Dec 2004 16:54:53 +0800
Message-ID: <cr341a$nl2@netnews.proxy.lucent.com>

Is it true?

With other articles, I learned that, the rowid will not change when physical address changes. When one row is moved to another block (row migration), the ROWID will still point to the orignal block, Oracle will keep the address to the other block in the orignal block.

So I feel it's almost impossible that the ROWID to be changed.

"Sybrand Bakker" <sybrandb_at_hccnet.nl> wrote in message
>
> Quoting the Oracle 7 documentation is not very useful, as the format
> of the rowid changed in Oracle 8.0.
> One of the components of the rowid is now the partition. As a row, by
> being updated, can move from one partition to another, the
> corresponding rowid will also be changed.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Fri Dec 31 2004 - 02:54:53 CST