You can not move a fake index. You can only drop and recreate it.


-----Original Message-----
From: Gary Colbran (RDB Consulting)
[mailto:oracledba-ezmlmshield-x59376516.[Email address protected]
Sent: Wednesday, September 06, 2006 1:52 AM
To: LazyDBA Discussion
Subject: Fake Index

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.



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page