|Oracle® Database SQL Language Reference
11g Release 2 (11.2)
Part Number E17118-03
The operator must be in your schema or you must have the
OPERATOR system privilege.
Specify the schema containing the operator. If you omit
schema, then Oracle Database assumes the operator is in your own schema.
Specify the name of the operator to be dropped.
FORCE to drop the operator even if it is currently being referenced by one or more schema objects, such as indextypes, packages, functions, procedures, and so on. The database marks any such dependent objects
FORCE, you cannot drop an operator if any schema objects reference it.
Dropping a User-Defined Operator: Example The following statement drops the operator
DROP OPERATOR eq_op;
FORCE clause is not specified, this operation will fail if any of the bindings of this operator are referenced by an indextype.