create table caishui.partition_test( id varchar2(9), tmpStr varchar2(10) ) partition by range(to_number(id))( partition id01 values less than (3000000), partition id02 values less than (6000000), partition id03 values less than (9000000), partition id04 values less than (12000000), partition id05 values less than (MAXVALUE) )
id varchar2(9),
tmpStr varchar2(10)
)
partition by range(to_number(id))(
partition id01 values less than (3000000),
partition id02 values less than (6000000),
partition id03 values less than (9000000),
partition id04 values less than (12000000),
partition id05 values less than (MAXVALUE)
)