| Partioning table [message #56243] |
Thu, 13 March 2003 09:01  |
Srini
Messages: 28
Registered: November 2000
|
Junior Member |
|
|
Hi,
Lets say there is a table EMP with partitions p1,p2,p3
If i want to select data from partion p1 then i write my select statement as
select * from emp partition (p1);
But i wanted to select data from partitions p1 and p2.
I want select statement which looks something like this
select * from emp partition (p1,p2);
I know the syntax i mentioned for above select is wrong.....
Could anyone please explore and write a select statement which fits
close to above statement
In worst case i may have to use the select statement below
select * from emp partition (p1)
union
select * from emp partion (p2);
Problem in using union is i have about 36 partitions and i have to
keep 35 union statements which i dont want to keep.
|
|
|
|
| Re: Partioning table [message #56250 is a reply to message #56243] |
Thu, 13 March 2003 20:45  |
waris
Messages: 115
Registered: November 2001
|
Senior Member |
|
|
Hi,
As per my knowledge i think there is no need for you to give partition name in ur query,
Just give a select from table name and Oracle will use the partitions on that table and
return you the resultent rows..by the way why do u want to specify partition name?? r u storing the same or duplicate values in more than one partition??
Cheers
waris
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
