December 2002
Intermediate to advanced
928 pages
85h 29m
English
Partition_Description_Clause
[Physical_Attributes_Clause]
[TABLESPACE tablespace_name]
[LOGGING | NOLOGGING]
[COMPRESS integer | NOCOMPRESS]
[OVERFLOW [Physical_Attributes_Clause]
[TABLESPACE tablespace_name]
[LOGGING | NOLOGGING]]
[{LOB_Storage_Clause| Varray_Storage_Clause}
[,{LOB_Storage_Clause| Varray_Storage_Clause}...]]
[{SUBPARTITIONS integer [STORE IN (tablespace_name[,tablespace_name ...])]
| SUBPARTITION [subpartition_name] [TABLESPACE tablespace_name]
[OVERFLOW [TABLESPACE tablespace_name]]
[{LOB_Storage_Clause| Varray_Storage_Clause}
[,{LOB_Storage_Clause| Varray_Storage_Clause}...]]
[,SUBPARTITION [subpartition_name] [TABLESPACE tablespace_name]
[OVERFLOW [TABLESPACE tablespace_name]]
[{LOB_Storage_Clause| Varray_Storage_Clause}
[,{LOB_Storage_Clause| Varray_Storage_Clause}...]
...)]
}]Specifies various physical storage parameters for partitions.
Specifies the physical attributes for this partition; see the next entry, “Physical_Attributes_Clause”.
Specifies the LOB storage parameters for this partition. See the “LOB_Storage_ Clause” entry earlier in this section.
Specifies that table rows of an index-organized table that exceed the PCTTHRESHOLD value be placed in a segment described in this clause.