Oracle. Table partitioning: Hash partition ____oracle

Oracle Table partitioning: Range Partitioning

Oracle. Table partitioning: Hash partitions

Oracle. Table partitions: List partitions

Oracle. Table partitions: Composite partitions

Oracle Table partitioning: manipulating partitioned tables

Allows users to partition data that does not have a logical scope
To determine a stored partition by executing a hash function on a partitioning key
Distribute data evenly to different partitions

Grammar:

PARTITION by HASH (column_name)
partitions number_of_partitions;

Or:

PARTITION by HASH (column_name)
(PARTITION part1 [tablespace tbs1],
  PARTITION part2 [tablespace TBS2],
  ... C4/>partition Partn [tablespace TBSN]);

Cases:

CREATE TABLE Employee
(
    employee_id varchar2 (5),
    employee_name varchar2,
    Department varchar2 (10 )
PARTITION by HASH (Department)
(
    PARTITION D1,
    PARTITION D2,
    PARTITION D3