Your syntax looks okay,.... what is the exact error you are encountering?

I have seen range partitions put up mostly on date fields.

Nevertheless consider the following to add partitions on your table,


To change an unpartitioned table to a range-partitioned table with three partitions, say, each of which is on a different segment:

alter table sample_tab partition by range (empno)
    (smallempno values <= (2000) on seg1,
    mediumempno values <= (4000) on seg2,
    bigempno values <= (6000) on seg3)

To add yet another range partition to the table:

alter table sample_tab add partition
    (vbigempno values <= (8000) on seg4)