Dropping partitioned index

[Fiona]

No to both questions I'm afraid.

[abhaysk]

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.

 
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.

[abhaysk]

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.

[pando]

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?

[millerg]

Hi, pando. When is your new book being released: "How to Lose Friends and Alienate People?"