Re: Spam:range partition issue

From: anysql <anysql_at_gmail.com>
Date: Thu, 15 Nov 2007 08:41:36 +0800
Message-ID: <200711150841265972468@gmail.com>

Hi:

I tested it in 9205 database, the result is correct.

SQL> @cr.sql
SQL> CREATE TABLE test_part
2 (

  3  ID_USAGE_INTERVAL             NUMBER(10)                 NOT NULL,
  4  ID_ACC     NUMBER(10)              NOT NULL

  5 )
  6 PARTITION BY RANGE (ID_USAGE_INTERVAL, ID_ACC)   7 (
  8 PARTITION USAGE_1 VALUES LESS THAN (897515520, 1500000),

  9      PARTITION USAGE_2 VALUES LESS THAN (897515520, 3500000)
 10      )

11 /

Table created.

SQL> insert into test_part values(897515520,1200000);

1 row created.

SQL> insert into test_part values(897515520,1600000);

1 row created.

SQL> commit;

Commit complete.

SQL>
SQL> select count(*) from test_part partition(usage_1);

COUNT(*)

SQL> select count(*) from test_part partition(usage_2) ;

COUNT(*)

SQL> Thanks.

Fangxin Lou, Oracle DBA, from China

Good tools make work easy and improve life quality
-- http://www.dbatools.net

Personal software, life, research and professional Oracle recovery service
-- http://www.anysql.net/en

http://www.anysql.net (Chinese)

From£º Harvinder Singh
Sent£º 2007-11-15 04:41:22
To£º oracle-l_at_webthere.com; oracle-l_at_freelists.org CC£º
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 Received on Wed Nov 14 2007 - 18:41:36 CST