Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
SQL Statements:
CREATE TYPE to
DROP ROLLBACK SEGMENT, 20 of 26
Use the DROP
OPERATOR
statement to drop a user-defined operator.
See Also:
|
The operator must be in your schema or you must have the DROP
ANY
OPERATOR
system privilege.
drop_operator::=
drop_operator
Specify the schema containing the operator. If you omit schema, Oracle assumes the operator is in your own schema.
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 (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.
DROP
OPERATOR
Example
The following statement drops the operator merge
:
DROP OPERATOR oe.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.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|