Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: table move changes rowids?
Michael J. Moore wrote:
> 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,
After a MOVE the indexes are INVALID and need to be rebuilt. Received on Sun Nov 16 2003 - 10:49:50 CST