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 -> Re: Question: Unusable indexes after tablespace move of table

Re: Question: Unusable indexes after tablespace move of table

From: <bdbafh_at_gmail.com>
Date: 29 Dec 2005 11:03:44 -0800
Message-ID: <1135883024.520577.306860@z14g2000cwz.googlegroups.com> 





As the index has the values for the indexed columns and the rowid of
the relevant row in the table, the prior rowid values are stale after
the move operation.



Check out the package dbms_rowid for methods of determining file,
extent and block info from a rowid.



hth


-bdbafh
Received on Thu Dec 29 2005 - 13:03:44 CST












Original text of this message













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