Cause
An attempt was made to create, alter or drop an index on temporary table which is already in use.
An attempt was made to create, alter or drop an index on temporary table which is already in use.
Using the CASCADE option with the DROP CONSTRAINT ONLINE statement is illegal. Remove the CASCADE keyword from the statement. Drop the child key constraint in a separate DROP CONSTRAINT ONLINE statement on the child table.
Try the following links for this error:
http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm
https://community.oracle.com/message/9350714
https://community.oracle.com/message/9550406
https://community.oracle.com/message/11008322
https://community.oracle.com/message/3168917
https://community.oracle.com/message/3359548
https://community.oracle.com/message/2052904
https://community.oracle.com/message/9416519
https://community.oracle.com/message/9154956
https://community.oracle.com/message/3503496
https://community.oracle.com/message/10948617
https://community.oracle.com/message/11037201
https://community.oracle.com/message/500660
https://community.oracle.com/message/404336
https://community.oracle.com/message/2258306
https://community.oracle.com/message/1690253
Browse all solutions to database errors from Oracle, MS SQL, or MySQL