Enable simultaneous ORACLE_COPIES and PARALLEL_TABLES
Brought to you by:
darold
It would be awesome if both ORACLE_COPIES and PARALLEL_TABLES could be implemented to work together. We are going to be creating an extraction job running from AWS and as such will have several CPUs available to us and it would awesome to extract multiple tables with each one running in parallel.
Anonymous
Hi,
Please use github (see http://ora2pg.darold.net/ ) to report issues or feature request. ORACLE_COPIES is used to split data export of one table over multiple Oracle connections. This require to be able to use a column as the key for query partitionning and can only be done on table with huge amount of data. The PARALLEL_TABLES directive allow you to export several tables at the same time. Being able to use both directives at the same time required that you set DEFINED_PK for all table where ORACLE_COPIES should applies. As you know this is not possible to use those directives at the same time, but I don't see any reason to not enable this feature. I will try to work on it.
Best regards