Originally posted by Fiona
I did try and rebuild it, only to get error message
ALTER INDEX BM7 REBUILD PARTITION P9 TABLESPACE P_3_NEW;
ERROR at line 1:
ORA-01418: specified index does not exist
DBA_SEGMENTS table clearly shows that old tablespace contains index BM7 and not in P_3_NEW where I want to rebuild it.
Jus check this might be the case.Had u created a index or partioned index with the name in doube quote ("indx_name")...ther lies the probs.
Code:
SQL> alter index emp_id rebuild;
alter index emp_id rebuild
*
ERROR at line 1:
ORA-01418: specified index does not exist
SQL> alter index "emp_id" rebuild;
Index altered.
Abhay.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Reply With Quote