DROP INDEX

Drop an index.

Syntax:

   DROP INDEX [schema.]index [FORCE]

FORCE can be used to drop domain indexes that are marked as IN_PROGRESS or are reporting errors.

"Anything you build on a large scale or with intense passion invites chaos" ~ Francis Ford Coppola

Related:

INDEX - CREATE INDEX
INDEX - ALTER INDEX

 DBA_INDEXES            ALL_INDEXES              USER_INDEXES
    INDEX_HISTOGRAM
    INDEX_STATS
 DBA_INDEXTYPES           ALL_INDEXTYPES           USER_INDEXTYPES
 DBA_INDEXTYPE_OPERATORS  ALL_INDEXTYPE_OPERATORS  USER_INDEXTYPE_OPERATORS
 DBA_IND_COLUMNS          ALL_IND_COLUMNS        USER_IND_COLUMNS
 DBA_IND_EXPRESSIONS      ALL_IND_EXPRESSIONS    USER_IND_EXPRESSIONS
 DBA_IND_PARTITIONS       ALL_IND_PARTITIONS     USER_IND_PARTITIONS
 DBA_IND_SUBPARTITIONS    ALL_IND_SUBPARTITIONS  USER_IND_SUBPARTITIONS


© Copyright SS64.com 1999-2014
Some rights reserved