only one proces returns rows from partitioned table

[jasper]

Hi,
I'm selecting data from an oracle stage(one table). When selecting without the partition table option (so with one process) I get 2000000 records back
(all records from table) . When I put the partition option and take a 16-node configfile It only returns 160000 records and stops without error.

I'm doing a likewise thing on other tables, where the parallel process works correctly. Difference is:
-other DB's are not behind a firewall, this one is
-it is a RAC setup

Any ideas if this has any impact, or is there some other problem?

[mahindru]

Hi,
I'm selecting data from an oracle stage(one table). When selecting without the partition table option (so with one process) I get 2000000 records back
(all records from table) . When I put the partition option and take a 16-node configfile It only returns 160000 records and stops without error.

I'm doing a likewise thing on other tables, where the parallel process works correctly. Difference is:
-other DB's are not behind a firewall, this one is
-it is a RAC setup

Any ideas if this has any impact, or is there some other problem?