Fake Indexes

[yekaterina]

RDBMS Version: 8.1.5.0.0
Operating System and Version: Solaris for Intel 5.7
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): Oracle Server
Product Version: 8.1.5.0.0

Fake Indexes

I've got an index called VDK_FAKE_IDX_12_17793 on one of my tables and I'm not sure how it got there. Is this a fake index? If so, what is a fake index and how did it get on my table? I can't find any documentation on fake indexes other that an explaination for ORA-8114 (can't alter a fake index).

[rsuri]

hmmm... this is the first time I heard about FAKE indexes;
I don't know how you can create one.
As per the documentation, you can't ALTER a fake index and the only resolution is to DROP it.
So I will say look into the Index definition and write a script to create one with the same name and then DROP the index.
If some users or Applications complain about this index, just run the script to recreate it.

If you have a development box with similar database, you may want to create that index there to make sure that their won't be any problems (with that index name) after you drop the index.