Skip Headers

Oracle9i SQL Reference
Release 2 (9.2)

Part Number A96540-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

DROP INDEXTYPE

Purpose

Use the DROP INDEXTYPE statement to drop an indextype, as well as any association with a statistics type.

See Also:

CREATE INDEXTYPE for more information on indextypes

Prerequisites

The indextype must be in your own schema or you must have the DROP ANY INDEXTYPE system privilege.

Syntax

drop_indextype::=

Text description of statements_851.gif follows
Text description of drop_indextype


Semantics

schema

Specify the schema containing the indextype. If you omit schema, Oracle assumes the indextype is in your own schema.

indextype

Specify the name of the indextype to be dropped.

If any statistics types have been associated with indextype, Oracle disassociates the statistics type from the indextype and drops any statistics that have been collected using the statistics type.

See Also:

ASSOCIATE STATISTICS and DISASSOCIATE STATISTICS for more information on statistics associations

FORCE

Specify FORCE to drop the indextype even if the indextype is currently being referenced by one or more domain indexes. Oracle marks those domain indexes INVALID. Without FORCE, you cannot drop an indextype if any domain indexes reference the indextype.

Example

Dropping an Indextype: Example

The following statement drops the indextype textindextype and marks INVALID any domain indexes defined on this indextype:

DROP INDEXTYPE textindextype FORCE;