OraFAQ Forum: SQL & PL/SQL » Unable to drop an Index

Home » SQL & PL/SQL » SQL & PL/SQL » Unable to drop an Index

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to drop an Index [message #635699]

Tue, 07 April 2015 02:28

msinha8
Messages: 43
Registered: March 2014
Location: Hyderbad

Member

Hi all,

I am facing an issue when I am trying to DROP an index but ending with below error

ORA-01418: specified index does not exist

But when i queried in user_indexes table , I am getting the index data.

SELECT *
FROM   user_indexes
WHERE  index_name = 'f_temp';

My DB version is :-

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

Does anyone have any idea about it ?

I have followed the similar topic here but I couldn't get any leads.

Thanks,
Mritunjay

Attachment: index_output.jpg
(Size: 18.38KB, Downloaded 632 times)

Report message to a moderator

Re: Unable to drop an Index [message #635700 is a reply to message #635699]

Tue, 07 April 2015 02:31

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Post the sqlplus output of the entire session.

I suspect a double quote issue.

Report message to a moderator

Re: Unable to drop an Index [message #635703 is a reply to message #635700]

Tue, 07 April 2015 02:46

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes, from image he posted, this is most likely the case.

Report message to a moderator

Re: Unable to drop an Index [message #635704 is a reply to message #635700]

Tue, 07 April 2015 02:47

msinha8
Messages: 43
Registered: March 2014
Location: Hyderbad

Member

Hi Roch,

I am Glad that you have responded me.

I don't have access to SQL+, so I am providing you complete session output from SQL developer.

Please let me know, If you are looking for something else.

Regards,
Mrit

Attachment: index_output_complete.jpg
(Size: 190.02KB, Downloaded 720 times)

Report message to a moderator

Re: Unable to drop an Index [message #635705 is a reply to message #635704]

Tue, 07 April 2015 02:49

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Someone has created an index with a name in lower case, find them and shoot them.

You'll need to drop the index referring to its name in double quotes "f_temp". It is the only way.

Report message to a moderator

Re: Unable to drop an Index [message #635706 is a reply to message #635705]

Tue, 07 April 2015 03:00

msinha8
Messages: 43
Registered: March 2014
Location: Hyderbad

Member

Thanks Roch,

You Saved my life!!!

After putting Double Quotes with index name, I am able to drop the same.

Regards,
Mrit

Report message to a moderator

Previous Topic:	Package Initialization block for performance tuning
Next Topic:	how to retreive the second word using substring

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 23:35:18 CDT 2024