CREATE TABLE t_cemal (t_no NUMBER NOT NULL, t_date DATE NOT NULL, t_comments VARCHAR2(100)) PARTITION BY RANGE (t_no) (PARTITION t_no4 VALUES LESS THAN (5) );But I want:
PARTITION BY RANGE (t_no) (PARTITION t_no4 VALUES EQUAL 5);What is correct syntax?
Why not create two partitions? The first partition will have all values less than 5. The second partition will have all values less than 6. This second parition can only contain the value five since all values less than five will be in the other partition.
Alternatively, you can look at List Partitioning. With list partitioning, you can have the first partition contains the values "1,2,3,4" and the second partition contain the values "5".
This was first published in May 2005