Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 7 of 30
To drop an indextype, as well as any association with a statistics type.
The indextype must be in your own schema or you must have the DROP
ANY
INDEXTYPE
system privilege.
schema |
is the schema containing the indextype. If you omit schema, Oracle assumes the indextype is in your own schema. |
|
indextype |
is 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. |
|
|
drops the indextype even if the indextype is currently being referenced by one or more domain indexes, and marks those domain indexes |
The following statement drops the indextype TEXTINDEXTYPE
and marks INVALID
any domain indexes defined on this indextype:
DROP INDEXTYPE textindextype FORCE;
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|