Re: Question: Unusable indexes after tablespace move of table
- From: bdbafh@xxxxxxxxx
- Date: 29 Dec 2005 11:03:44 -0800
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
.
- Follow-Ups:
- References:
- Prev by Date: Re: Autoincrement numeric primary key data type
- Next by Date: Version of the JVM /JDK installed in Oracle
- Previous by thread: Question: Unusable indexes after tablespace move of table
- Next by thread: Re: Question: Unusable indexes after tablespace move of table
- Index(es):
