Thanks for the question, Dilip.
Asked: July 31, 2024 - 2:24 am UTC
Last updated: August 05, 2024 - 7:18 am UTC
Version: Oracle 19C
Viewed 100+ times
SQL> create table t ( x int primary key , y int ) 2 organization index 3 partition by hash ( x ) partitions 8; Table created. SQL> create table t ( x int primary key , y int ) 2 organization index 3 partition by range ( x ) 4 ( partition p1 values less than (1000), 5 partition p2 values less than (maxvalue)); Table created.
If you are new to partitioning, check out Connor McDonald's introduction series here.
Documentation set on VLDB and Partitioning.