ORA-14418: Online DDL's cannot be used with this constraint type.

ORA-14418: Online DDL's cannot be used with this constraint type.


Cause:


An attempt was made to use the DROP CONSTRAINT ONLINE or SET UNUSED COLUMN ONLINE statement on a constraint type other than check, primary key, unique, referential, or not null constraint.



Action:


Using DROP CONSTRAINT ONLINE or SET UNUSED COLUMN ONLINE statement on any other constraint types excluding check, primary key, unique, referential, or not null constraints is illegal. Remove the ONLINE keyword from the DDL.