Re: row migaration

From: <xhoster_at_gmail.com>
Date: 04 Jan 2006 16:43:07 GMT
Message-ID: <20060104114307.156$oL@newsreader.com>

"Scarab" <yw_at_lucent.com> wrote:
> Hi,
> What is row migaration?
> Does it means that when I select some rowid from a table, and after row
> migaration, the rowid may be changed?

In addition to the row migration due to with-in block space problems mentioned elsewhere in this thread, there is also row migration across the partitions of a partitioned table when the partitioning key of the row is updated. As far as I know, this kind of partitioning leaves no tombstones, and hence the rowid would indeed change.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB

Received on Wed Jan 04 2006 - 10:43:07 CST