-
No to both questions I'm afraid.
-
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"
-
Originally posted by slimdave
Your index name isn't mixed case or anything is it, or owned by a different user?
gues we posted almost same time.
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"
-
the thing is you first said you get
ORA-01418: specified index does not exist
then how come you can rebuild an index which does not exist?
then it seems that you can see the index in dba_ind_partitions so I am wondering, are you rebuilding the index with the proper user?
-
Hi, pando. When is your new book being released: "How to Lose Friends and Alienate People?"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|