Using the LOAD
export type and a file containing SQL orders to perform, it is possible to dispatch those orders over multiple Postgres Pro connections. To be able to use this feature, PG_DSN
, PG_USER
and PG_PWD
must be set.
ora2pgpro -t LOAD -c config/ora2pgpro.conf -i schema/tables/INDEXES_table.sql -j 4
This will dispatch indexes creation over 4 simultaneous Postgres Pro connections. This will considerably accelerate this part of the migration process with huge data size.