Hi,
I have a partitioned Oracle table that partitioned by the monthly. How can I read only one partition via the Parallel Job.
Best Regards
MAli
Oracle Partitioned Table
Moderators: chulett, rschirm, roy
Re: Oracle Partitioned Table
You need not specify the partition , if you have a "where clause" that confines your data within the partition. Say you have a month partition and your query has a "where clause" like month_id='AUG.2006", then the oracle optimizer is intelligent enough to access only that partition.mali_aydin wrote:Hi,
I have a partitioned Oracle table that partitioned by the monthly. How can I read only one partition via the Parallel Job.
Best Regards
MAli
if your "where clause" doesnt have the month where clause, then specifiy the "PARTITION CLAUSE" in the select statement
regards,
Prabu
Create user-defined sql query in the where clause assign a parameter with #month# and while running the job supply the month value. Oracle will then automatically does the magic...
Regards
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar