Cause
An attempt was made to use the DROP CONSTRAINT ONLINE or SET UNUSED COLUMN ONLINE statement on constraint states (for example, deferrable, deferred) that was not allowed.
An attempt was made to use the DROP CONSTRAINT ONLINE or SET UNUSED COLUMN ONLINE statement on constraint states (for example, deferrable, deferred) that was not allowed.
Using the DROP INDEX ONLINE statement on certain types of indexes (for example, indexed-organized table (IOT), cluster, LOB, domain indexes) is illegal. Remove the ONLINE keyword from the statement.
Try the following links for this error:
http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm
Browse all solutions to database errors from Oracle, MS SQL, or MySQL