'AWS RDS Oracle: Synch Specific Schema to Test Environment

I want to sync data of specific Oracle Schemas, not ddl.

Both instances in AWS RDS.

Want to automate it to regularly Copy PROD to DEV. (once a month)

How to do it effectively?

Regards and thanks in advance.

Vincent

oracle discord

Solution 1:^[1]

It depends on the size of the Oracle Schema you are referring. There are choices available according to that.

Oracle Data pump would be the ideal option to automate your requirements. There are details available in the link. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Procedural.Importing.html

Regards, Suraj

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	Suraj Ramesh