Any problems anyone can forsee if I drop/create rather then move these?

SQL> alter index QUERY.QUEST_SX_1B010D596F21703D687B rebuild tablespace SIYAYA_INDX1;
alter index QUERY.QUEST_SX_1B010D596F21703D687B rebuild tablespace SIYAYA_INDX1
*
ERROR at line 1:
ORA-08114: can not alter a fake index


SQL> host oerr ora 8114
08114, 00000, "can not alter a fake index"
// *Cause: User attempted to alter a fake index
// *Action: drop fake index

What is it anyway?

Disclaimer
This e-mail and any attachments transmitted with it are confidential and intended solely for the use of the individual or entity to whom it is addressed. If you have received this e-mail in error please notify the sender and delete the original message. Any views or opinion expressed in this e-mail are those of the author and do not necessarily represent those of the Department of Labour. The recipient should check this e-mail and any attachments for the presence of viruses and other destructive codes. While all possible precautions have been taken, the Department accepts no liability whatsoever for loss or damage resulting from the opening of this message or attachments, or the use of the information contained in this message or attachment.


Oracle LazyDBA home page