Dropping partitioned index

No to both questions I'm afraid.

Quote:

---

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.

Quote:

---

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.

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?"