Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> table move changes rowids?

table move changes rowids?

From: Michael J. Moore <NOhicamelSPAM_at_comcast.net>
Date: Sun, 16 Nov 2003 16:17:12 GMT
Message-ID: <cqNtb.167658$ao4.541878@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 - 10:17:12 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US