only one proces returns rows from partitioned table
Posted: Mon Jul 25, 2005 5:50 am
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?
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?