DSXchange

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

You can hard code this partition into the table name. You could also create a parameter which represents the name and feed it into the job.

But I doubt if that was what you were really asking.

How about a where clause on the partition key column. This will be very efficient.

I have a partitioned table that is partitioned on column extract_date. When I select out of it I select where extract = YYYYMMDD.

Hope this helps.

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

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.

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...