Oracle also supports Hash based partitioning for fragmentation. It can do so in order to create the main partitions or for sub-partitions it further in conjunction with RANGE-HASH, HASH-RANGE, LIST-HASH, HASH-LIST, or HASH-HASH partitioning.
Tag: Oracle
Lab on Partitioning using Oracle 18C
Partiotioning in Oracle allows to subdivide a whole large logical object like table into smaller physical objects termed as partitions. The working principles of these physical partitioning helps to improve the performance, availability and manageability of applications that is built using this feature.