Relative file number changes...so does Block number....when u move a segment from one tablespace to other.
Due to which RowId changes & index will be holding OLD rowid so it goes to INVALID state.
Abhay.
|
Results 1 to 10 of 17
Thread: Index gets into invalid statusThreaded View
|
Click Here to Expand Forum to Full Width |