Re: Spam:range partition issue
- From: John D Parker <orclwzrd@xxxxxxxxx>
- To: Harvinder.Singh@xxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 14 Nov 2007 13:38:52 -0800 (PST)
Strangely enough I was researching a similar issue for a problem we are having
with an internal app. After reviewing Jonathan Lewis Practical 8i(still
applies) and looking at page 17-5 in the database admin guide for 10g, I found
the following article on line.
http://oraclesponge.wordpress.com/2007/01/14/thoughts-on-range-range-composite-partitioning/
Hopefully it will be as helpful to you as it was to us. Two column partitioning
it turns out is not like two dimentional arrays. We found all our data in the
lowest matching partition when it should be scattered across several.
The info in the above resources was quite helpful. I'd explain it but they do a
much better job. Now if I could just find the reference pages for ANSI SQL2
Vector Comparison...
John
Harvinder Singh <Harvinder.Singh@xxxxxxxxxxxxx> wrote: 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
---------------------------------
Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how.
Other related posts:
