Hello,
I am migrating an Oracle database to Azure Database for PostgreSQL using ora2pg. Unfortunately, ora2pg is not very efficient with migrating partitioned Oracle tables and I have to do this manually. A very huge amount of data is involved and so, I want to find the easiest way to get this done (4 degree of parallelism).
Could someone please, advice me about the easiest way to select data from a partitioned oracle 12c table that has either local / global indexes and foreign keys? Also, how can I spin it for 4 degree of parallelism?
Thank you.
Regards,
Sahoong