Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Spam:range partition issue
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 NULL5 )
9 PARTITION USAGE_2 VALUES LESS THAN (897515520, 3500000) 10 )
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(*)
1
SQL> select count(*) from test_part partition(usage_2) ;
COUNT(*)
1
SQL> Thanks.
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
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)
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
![]() |
![]() |