Spam:range partition issue

Hi,  

I am creating range partitioning on 2 columns as following:  

CREATE TABLE test_part

(

Col1             NUMBER(10)                 NOT NULL,

Col2  NUMBER(10)                 NOT NULL

)

TABLESPACE tab_1

PARTITION BY RANGE (ID_USAGE_INTERVAL, ID_ACC) (

  PARTITION USAGE_1 VALUES LESS THAN (897515520, 1500000)     TABLESPACE tab_2,

  PARTITION USAGE_2 VALUES LESS THAN (897515520, 3500000)     TABLESPACE tab_3

)
 

insert into test_part values(897515520,1200000)

insert into test_part values(897515520,1600000)

commit  

select count(*) from test_part partition(usage_1)  

select count(*) from test_part partition(usage_2)  

I expect both the partitions usage1 and usage2 to have 1 row each but both the rows are going to usage1, What can be the possible issue?  

Thanks

--Harvinder  

--
http://www.freelists.org/webpage/oracle-l