Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01502: index or partition of such index is in usable (Oracle 12C (12.1.0.2.0))
ORA-01502: index or partition of such index is in usable [message #667165] Tue, 12 December 2017 04:05 Go to next message
takwadin
Messages: 2
Registered: December 2017
Junior Member
Hi,
After doing :
Alter session enable parallel dml;
Alter session set skip_unusable_indexes = true;
Alter index xxx UNUSABLE;

i have a problem when insert data in the table with the error message : "ORA-01502: index or partition of such index is in usable".

So, my version of oracle is the 12c (12.1.0.2.0)

Thanks for your help.
Re: ORA-01502: index or partition of such index is in usable [message #667166 is a reply to message #667165] Tue, 12 December 2017 04:09 Go to previous messageGo to next message
John Watson
Messages: 7265
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

If the index is used to enforce a constraint, you would need to disable the constraint before you can do an INSERT.
Re: ORA-01502: index or partition of such index is in usable [message #667167 is a reply to message #667166] Tue, 12 December 2017 05:02 Go to previous messageGo to next message
takwadin
Messages: 2
Registered: December 2017
Junior Member
I do it but i have the same error.
Re: ORA-01502: index or partition of such index is in usable [message #667168 is a reply to message #667167] Tue, 12 December 2017 05:09 Go to previous message
John Watson
Messages: 7265
Registered: January 2010
Location: Global Village
Senior Member
You will need to show what you did. Use SQL*Plus, and copy/paste everything here. Please remember to enclose it within [code] tags.
Previous Topic: i need to know hows this happening?
Next Topic: Retrieve column names with aliases
Goto Forum:
  


Current Time: Sat Feb 24 09:15:11 CST 2018

Total time taken to generate the page: 0.01206 seconds