December 2002
Intermediate to advanced
928 pages
85h 29m
English
Partition_Clause
{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 ...