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,

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 ongoing
replication 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-l
Received on Mon May 15 2023 - 19:27:36 CEST

Original text of this message