Migrating partition table from Oracle to aurora postgreSQL
From: Arun Chugh <arun.chugh1610_at_gmail.com>
Date: Mon, 15 May 2023 22:57:36 +0530
Message-ID: <CAOyn3GeK3sF3MDkuh0KP9sTmM055ps-72WGDA7T=XP9Fu-HS9g_at_mail.gmail.com>
Hello All,
Date: Mon, 15 May 2023 22:57:36 +0530
Message-ID: <CAOyn3GeK3sF3MDkuh0KP9sTmM055ps-72WGDA7T=XP9Fu-HS9g_at_mail.gmail.com>
Hello All,
Does anyone have experience of migrating the partition table (partition by list) from Oracle database to Aurora postgreSQL by using AWS DMS...
We are able to load the existing data, but ongoing replication is not happening.. so need support and valuable input.
1- Enable the supplemental logging 2- Enable logging by using unique index 3- create 3 different DMS tasks based on the list of partitions 4- start the DMS tasks, initial load happened successfully, but ongoingreplication is not happening.
5- DMS tasks status showing as "load complete, ongoing replication"
No error messages are coming , but changes are not applied.. whereas rest all the tables are replicating exactly fine.
Regards,
Arun Chugh
-- http://www.freelists.org/webpage/oracle-lReceived on Mon May 15 2023 - 19:27:36 CEST