DROP OPERATOR

Syntax

Purpose

To drop a user-defined operator.

See Also: "User-Defined Operators", Oracle8i Data Cartridge Developer's Guide and "CREATE OPERATOR" for more information on operators.

Prerequisites

The operator must be in your schema or you must have the DROP ANY OPERATOR system privilege.

Keywords and Parameters

schema	is the schema containing the operator. If you omit schema, Oracle assumes the operator is in your own schema.
operator	specifies the name of the operator to be dropped.
FORCE	drops the operator even if it is currently being referenced by one or more schema objects (indextypes, packages, functions, procedures, and so on), and marks those dependent objects INVALID. Without FORCE, you cannot drop an operator if any schema objects reference it.

Example

The following statement drops the operator MERGE:

DROP OPERATOR ordsys.merge;

Because the FORCE clause is not specified, this operation will fail if any of the bindings of this operator are referenced by an indextype.