Oracle Database Discussions

hi All ,

I need to Range partition the table based on a particular value ..please see the details below.

create table K_VAL_RT(RT number(3),PKP_ET number(9),VALUE varchar2(4),STAT char(1))
partition by range (RT)
(
partition part_1 values less than (1)
partition part_2 values less than (2)
.
.
.
.
.
partition part_24 values less than (24)
partition part_25 values less than (maxvalue)
);
Now the problem i am facing is some times value of RT can be null .
when insert happens like below
insert into K_VAL_RT values(null,67,'RXF','A')
its giving me an error ORA-14400:inserted partition key doesn't map to any partition
My requirement is that if RT is null it should go to partition part_1 (value less than 1) .
How can i define such a rule ..
please help
Thanks

Edited by: am_73798 on May 6, 2009 11:59 PM