|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-02
OPERATOR statement to compile an existing operator.
The operator must be in your own or another schema, or you must have the
OPERATOR system privilege.
Specify the schema containing the operator. If you omit this clause, Oracle assumes the operator is in your own schema.
Specify the name of the operator to be recompiled.
COMPILE to cause Oracle to recompile the operator. The
COMPILE keyword is required.
The following example compiles the operator
eq_op (which was created in "Creating User-Defined Operators: Example"):