I want to create a partitioned table on two columns.
So i created range partition. But when i inserted records, the values are not storing in a proper partitions. Pl. help to create the correct partitioned table....

It is very urgent.

Thanks in advance...

Here is the create script. Very Very urgent....

create table abc1 (countrycode varchar2(2), mis_date date)
partition by range (mis_date, countrycode)
(partition AU_200202 values less than (to_date('01-MAR-2002', 'DD-MON-YYYY'), 'AV')
storage(initial 40960 next 40960) tablespace data,
partition HK_200202 values less than (to_date('01-MAR-2002', 'DD-MON-YYYY'), 'HL')
storage(initial 40960 next 40960) tablespace data,
partition AU_200203 values less than (to_date('01-APR-2002', 'DD-MON-YYYY'), 'AV')
storage(initial 40960 next 40960) tablespace history,
partition BH_200203 values less than (to_date('01-APR-2002', 'DD-MON-YYYY'), 'BI')
storage(initial 40960 next 40960) tablespace history)

Regards,
S.Kumar