Specified index cannot be used to enforce the constraint.

Try the following links for this error:

http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm

https://community.oracle.com/message/2266061

https://community.oracle.com/message/9896051

https://community.oracle.com/message/11298725

https://community.oracle.com/message/3614666

https://community.oracle.com/message/9870125

https://community.oracle.com/message/10265772

https://community.oracle.com/message/9856049

https://community.oracle.com/message/1826241

https://community.oracle.com/message/10724462

https://community.oracle.com/message/1944761

https://community.oracle.com/message/1544651

Browse all solutions to database errors from Oracle, MS SQL, or MySQL