|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-02
INDEXTYPE statement to create an indextype, which is an object that specifies the routines that manage a domain (application-specific) index. Indextypes reside in the same namespace as tables, views, and other schema objects. This statement binds the indextype name to an implementation type, which in turn specifies and refers to user-defined index functions and procedures that implement the indextype.
Oracle9i Data Cartridge Developer's Guide and Oracle9i Database Concepts for more information on implementing indextypes
To create an indextype in your own schema, you must have the
INDEXTYPE system privilege. To create an indextype in another schema, you must have
INDEXTYPE system privilege. In either case, you must have the
EXECUTE object privilege on the implementation type and the supported operators.
An indextype supports one or more operators, so before creating an indextype, you should first design the operator or operators to be supported and provide functional implementation for those operators.
Specify the name of the schema in which the indextype resides. If you omit
schema, Oracle creates the indextype in your own schema.
Specify the name of the indextype to be created.
FOR clause to specify the list of operators supported by the indextype.
schema, specify the schema containing the operator. If you omit
schema, Oracle assumes the operator is in your own schema.
operator, specify the name of the operator supported by the indextype.
All the operators listed in this clause should be valid operators.
parameter_type, list the types of parameters to the operator.
USING clause lets you specify the type that provides the implementation for the new indextype.
implementation_type, specify the name of the type that implements the appropriate Oracle Data Cartridge interface (ODCI).
Oracle9i Data Cartridge Developer's Guide for additional information on this interface
The following statement creates an indextype named
position_indextype and specifies the
position_between operator that is supported by the indextype and the
position_im type that implements the index interface. Please refer to "Using Extensible Indexing" for an extensible indexing scenario that uses this indextype:
CREATE INDEXTYPE position_indextype FOR position_between(NUMBER, NUMBER, NUMBER) USING position_im;