Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 10 of 20
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. |
To create an indextype in your own schema, you must have the CREATE INDEXTYPE
system privilege. To create an indextype in another schema, you must have CREATE ANY 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.
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:
CREATE INDEXTYPE TextIndexType FOR contains (VARCHAR2, VARCHAR2) USING TextIndexMethods;
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|