ALTER OPERATOR

Purpose

Use the ALTER OPERATOR statement to compile an existing operator.

Prerequisites

The operator must be in your own or another schema, or you must have the ALTER ANY OPERATOR system privilege.

Syntax

alter_operator::=

Text description of alter_operator

Semantics

schema

Specify the schema containing the operator. If you omit this clause, Oracle assumes the operator is in your own schema.

operator

Specify the name of the operator to be recompiled.

COMPILE

Specify COMPILE to cause Oracle to recompile the operator. The COMPILE keyword is required.

Examples

Compiling a User-defined Operator: Example

The following example compiles the operator eq_op (which was created in "Creating User-Defined Operators: Example"):

ALTER OPERATOR eq_op COMPILE;