you can try REBUILDing the index (if you have enough space in the datafiles). This will recreate the index and may show you errors if the disk is corrupt.
Halo,
I didn't know the indexes would be unusable by moving the tables. whay would that happen ?
- Rajeev




Reply With Quote