Hash partitioning is one of the partitioning method, where hash algorithm is used to distribute data equally among multiple partitions.

It is usually used for large tables, where we can’t use RANGE key, and column contains lot of distinct value.

EXAMPLE:

TABLE WITH HASH PARTITION:(WITH PREDEFINED PARTITION_NAME)

TABLE WITH HASH PARTITION:(WITH DEFAULT PARTITION_NAME)

While creating hash partitioned , if we don’t define the partitions names, then default partition names like SYS_% will be created.

COMPOSIT HASH PARTITION:

Composit hash partitioning means, A table is divided into multiple partitions, and again each partition is divided multiple sub partitions.

Here we are creating a table, with 4 hash partitions, and each partitions has 8 subpartitions(HASH).