OraFAQ Forum: SQL & PL/SQL » ORA-01502: index or partition of such index is in usable

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))

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

ORA-01502: index or partition of such index is in usable [message #667165]

Tue, 12 December 2017 04:05

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.

Report message to a moderator

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

John Watson
Messages: 8929
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.

Report message to a moderator