| René Nyffenegger's collection of things on the web | |
|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
Subpartition by hash clause [Oracle SQL] | ||
subpartition by hash ( column-name-1 [ ... , column-name-n ] )
or
subpartition by hash ( column-name-1 [ ... , column-name-n ] ) subpartitions number-of-subpartitions [ store in ( tablespace-1 [ ... , tablespace-n ] ) ]
or
subpartition by hash ( column-name-1 [ ... , column-name-n ] ) subpartition-template
The subpartition by hash clause appears as part within the
composite partitioning clause.
|