Oracle in a Nutshell

Name

CREATE/DROP INDEXTYPE

Synopsis

CREATE Syntax:

CREATE INDEXTYPE [schema.]indextype
FOR [schema.]operator (parm_type[,parm_type...])[,[schema.]operator...]
USING [schema.]implementation_type

DROP Syntax:

DROP INDEXTYPE [schema.]indextype

Creates or removes an indextype object for use in managing a domain index. New with Oracle8i.

Keywords

indextype

Name of the indextype object.

FOR

Specifies a list of operators supported by this indextype.

operator

Name of an operator.

parm_type

Specifies a type of parameter to the operator.

USING

Specifies the type that provides the implementation for the indextype.

implementation_type

Name of a type that implements an Oracle Data Cartridge interface (ODCI).

Common keywords and clauses: schema.