René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

Hash partitions by quantity [Oracle SQL clause]

partitions number-of-partitions [ store in (tablespace-name-1 [..., tablespace-name-n] )
[ overflow store in ( tablespace-name-q [ ... , tablespace-name-r ] ) ]  -- only valid in index organized tables ??
The overflow store in cannot be used with heap tables.
The hash partitions by quantity clause appears as part within the hash partitioning clause.

Examples

create table hash_partitioned_tab ( 
  foo number constraint hash_partitioned_pk primary key,
  bar varchar2(40) not null,
  baz date
) 
partition by hash (foo) 
partitions 4
store in (ts_1, ts_2);

create table hash_iot_tab (
  foo number,
  bar number,
  baz date,
  primary key (foo, bar) 
)
organization index
including bar overflow
partition by hash (bar)
partitions 4
store in          (ts_1, ts_2)
overflow store in (ts_3, ts_4);