Re: table move changes rowids?

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Sun, 16 Nov 2003 13:07:20 -0600
Message-ID: <vrfin9g9l1mt08@corp.supernews.com>

Check the status of the indexes after the MOVE. You will see that they are invalid.
You will either need to rebuild them, or drop and recreate them.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'

"Michael J. Moore" <NOhicamelSPAM_at_comcast.net> wrote in message news:cqNtb.167658$ao4.541878_at_attbi_s51...
> It would seem to me that a table move (especially to a different
tablespace)
> must create different rowids. After all, there is at least the potential
> that the relative file number might change. Right? Well, if this is true,
> how can indexes on the moved table still point to the appropriated table
> rows? Does the MOVE repopulate the rowids into all concerned indexes?
> Thanks,
> Mike
>
>
Received on Sun Nov 16 2003 - 13:07:20 CST