Oracle in a Nutshell

Name

CREATE/ALTER/DROP INDEX

Synopsis

CREATE Syntax:

CREATE [OR REPLACE] [UNIQUE | BITMAP] INDEX [schema.]indexname ON 
{ CLUSTER [schema.]cluster
                          Index_Attributes_Clause
| [schema.] table_name [alias] ({column | col_expr} [ASC | DESC] 
  [,{column|col_expr} [ASC | DESC] ...]) 
  [{ { {GLOBAL PARTITION BY RANGE (column_list) 
          (PARTITION partition_name VALUES LESS THAN (value[, value...])
           [Physical_Attributes_Clause]
           [TABLESPACE tablespace_name]
           [LOGGING | NOLOGGING]
       | LOCAL (PARTITION partition_name 
          [Physical_Attributes_Clause] 
          [TABLESPACE tablespace_name]
          [LOGGING | NOLOGGING]
          [,PARTITION partition_name
           [Physical_Attributes_Clause] 
           [TABLESPACE tablespace_name] 
           [LOGGING | NOLOGGING] ...])
       | LOCAL 
         {STORE IN ({tablespace_name[,tablespace_name...]|DEFAULT}) 
         | (PARTITION [partition_name] [TABLESPACE tablespace_name]
               [,PARTITION [partition_name] [TABLESPACE tablespace_name] ...])
         }
       | LOCAL STORE IN ({tablespace_name[,tablespace_name ...] | DEFAULT})
         (PARTITION [partition_name]
          [Index_Attributes_Clause]
          { STORE IN { tablespace_name[,tablespace_name ...] | DEFAULT} 
          | (SUBPARTITION subpartition_name [TABLESPACE tablespace_name]
            [,SUBPARTITION subpartition_name [TABLESPACE tablespace_name] ...])
          }   
           }
     | Index_Attributes_Clause
     }
   | INDEXTYPE IS indextype 
     [PARALLEL | NOPARALLEL]
     [PARAMETERS('parmstring')]
   }
| [schema.] table_name ([schema.]table_name column [{ASC | DESC}]
  [,[schema.]table_name column [{ASC | DESC}]...])
  FROM [schema.] table_name [,[schema.] table_name...] WHERE condition { LOCAL (PARTITION ...