• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3675
  • Last Modified:

select from partition range?

Is it possible to select from a partition range?

ie.

something like

select * from table partition range (partition1,partition3);

0
morphman
Asked:
morphman
2 Solutions
 
seazodiacCommented:
well, if you have a LOCAL index (as opposed to global),

you can achieve the same goal
by specifying the where clause :

for example: partition1 has the partition key from 1-50.
partition3 from 100-150.

you can do sth like this:

select * from <table_name>
where partition_key between 1 and 50
UNION
select * from <table_name>
where partition_key between 100 and 150.
0
 
pratikroyCommented:
Not that I know of.

But you can certainly create a view that has the data from the range of partitions that you are interested in and select from the view.

e.g.,

create or replace view emp3 as
select * from emp partition (p1)
union all
select * from emp partition (p2)
union all
select * from emp partition (p3);

Hope that would help
0
 
sujit_kumarCommented:
select p_no, empno from (
select 1 p_no, empno from emp partition (p1)
union all
select 2 p_no, empno  from emp partition (p2)
union all
select 3 p_no, empno  from emp partition (p3))
where p_no betwee 1 and 2;

0
 
morphmanAuthor Commented:
I guess the answer is no then..
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now