Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
|
|
View PDF |
Purpose
Use the DROP
OPERATOR
statement to drop a user-defined operator.
See Also:
CREATE OPERATOR and ALTER OPERATOR for information on creating and modifying operators
"User-Defined Operators" and Oracle Data Cartridge Developer's Guide for more information on operators in general
ALTER INDEXTYPE for information on dropping an operator of a user-defined indextype
Prerequisites
The operator must be in your schema or you must have the DROP
ANY
OPERATOR
system privilege.
Syntax
drop_operator::=
Semantics
schema
Specify the schema containing the operator. If you omit schema
, then Oracle Database assumes the operator is in your own schema.
operator
Specify the name of the operator to be dropped.
Specify 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 INVALID
. Without FORCE
, you cannot drop an operator if any schema objects reference it.
Example
Dropping a User-Defined Operator: Example The following statement drops the operator eq_op
:
DROP OPERATOR eq_op;
Because the FORCE
clause is not specified, this operation will fail if any of the bindings of this operator are referenced by an indextype.