RE: Spam:range partition issue

Harvinder,

This worked fine for me. Your "partition range" clause is wrong I think. You need to name the column names correctly:  

PARTITION BY RANGE (col1,col2)    

Tom

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Harvinder Singh Sent: Wednesday, November 14, 2007 3:37 PM To: oracle-l_at_webthere.com; oracle-l_at_freelists.org Subject: 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