Oracle Error ORA-29967: Cannot drop an operator binding with dependent objects

Oracle Error Message

ORA-29967: Cannot drop an operator binding with dependent objects

Reason for the Error

The operator binding that is being dropped has dependent objects.

Solution

Either drop the dependent objects first and then issue the ALTER OPERATOR DROP BINDING command or specify the FORCE option with ALTER OPERATOR DROP BINDING.