Re: Will ROWID change during DB Runing??

BTW,
The table have about 80K records and have index on it. When will the data partition move? frequent insert or delete? As I know, we have no such operation.
Will very frequent update can cause partition move?

Thanks very much!
Best Regards,
Grant

"Grant Zhou" <grantzhou_at_gmail.com> wrote in message news:cr341a$nl2_at_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 - 03:08:41 CST