Oracle in a Nutshell

Name

Partition_Clause

Synopsis

{PARTITION BY RANGE (column[,column...])
 (PARTITION [partition_name] 
   VALUES LESS THAN ({value | MAXVALUE}[,({value | MAXVALUE}...])
   [LOB_Storage_Clause]    
   [Physical_Attributes_Clause]
   [TABLESPACE tablespace_name]
   [LOGGING | NOLOGGING]
   [{ SUBPARTITIONS integer [STORE IN (tablespace_name[,tablespace_name...]])
    | (SUBPARTITION [subpartition_name] [TABLESPACE tablespace_name]
        [LOB_Storage_Clause]
        [, SUBPARTITION [subpartition_name] [TABLESPACE tablespace_name] 
          [LOB_Storage_Clause] ...])
      }
   [,(PARTITION [partition_name] 
     VALUES LESS THAN ({value | MAXVALUE}[,({value | MAXVALUE}...)
     [LOB_Storage_Clause]    
     [Physical_Attributes_Clause]
     [TABLESPACE tablespace_name]
     [LOGGING | NOLOGGING]
     [{ SUBPARTITIONS integer [STORE IN (tablespace_name[,tablespace_name ...])
      | (SUBPARTITION [subpartition_name] [TABLESPACE tablespace_name]
          [LOB_Storage_Clause]
          [, SUBPARTITION [subpartition_name] [TABLESPACE tablespace_name] 
            [LOB_Storage_Clause] ...])
      }
| PARTITION BY LIST (column)
  (PARTITIONS partition_name VALUES ({value | NULL}
    [,{value | NULL}...]
  [Partition_Description_Clause]
  [,PARTITIONS partition_name VALUES ({value | NULL}
    [,{value | NULL}...]
  [Partition_Description_Clause]...])

| PARTITION BY HASH (column[,column ...])
  [{PARTITIONS integer [STORE IN (tablespace_name[,tablespace_name ...])
   | (PARTITION [partition_name] [TABLESPACE tablespace_name]
      [LOB_Storage_Clause]
     [, PARTITION [partition_name] [TABLESPACE tablespace_name]
      [LOB_Storage_Clause] 
          ...]
   }
}

Specifies partitioning ...