CREATE INDEXTYPE

Purpose

Use the CREATEINDEXTYPE 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.

See Also: Oracle8i Data Cartridge Developer's Guide and Oracle8i Concepts for more information on implementing indextypes

Prerequisites

To create an indextype in your own schema, you must have the CREATEINDEXTYPE system privilege. To create an indextype in another schema, you must have CREATEANYINDEXTYPE 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.

Example

CREATEINDEXTYPE Example

The following statement creates an indextype named TextIndexType and specifies the contains operator that is supported by the indextype and the TextIndexMethods type that implements the index interface: