I didnt get much of what is RPT.
but when you did new table and renamed to old table name later. Did you enable supplemental logging and restarted GG.
- steps shd be something like below:
- stop extract
- stop replicat
- do the table changes
- enable logging
- start replicat
- start extract
Mark this correct, helpful or like it appropriately. It will help others
I assume you call your target schema RPT. Before you point the finger at OGG, check that it is indeed OGG that does it. All DDL operations which i assume you are replicating will be logged into the report files. Search for the drop table.
In addition your partitions between source and target need not have to match, you can have partitions on one side and not the other.
For partitioning unless you have matching set ups on both databases, it is better to do them separately on both. Stop the DDL replication for this table, do the partitioning and re-enable DDL. As I have said, your partitions need not have to match for replication to work.