Partition_Clause
{PARTITION BY RANGE (column[,column...])
  PARTITION [partition_name] VALUES LESS THAN (value_list)
     [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_list)
     [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 RANGE (column[,column ...])
   [SUBPARTITION BY HASH (column[,column] 
     [SUBPARTITIONS integer [STORE IN (tablespace_name[,tablespace_name ...]]]]
  {PARTITION [partition_name] VALUES LESS THAN (value_list)
     [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 [, LOB_storage_clause ...]
          [, SUBPARTITION [subpartition_name] [TABLESPACE tablespace_name]
          [LOB_Storage_Clause [, LOB_storage_clause ...

Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial