Move Replicated Data to a Different Target Database

In data replication, if you change the target database, you can migrate the current data to the new database, and reconfigure your connections to replicate to your new database.

For example, you might need to do this if your organization migrates from Oracle Cloud Infrastructure - Classic to Oracle Cloud Infrastructure.

1. Make sure that your new target schema has the required privileges and permissions. See What Privileges and Permissions Are Required?.
2. Copy the replicated tables and the following replication system tables to the new target schema.
   • All replicated tables (along with corresponding indexes, constraints)
   • REPL$_ERR_SUMMARY
   • E$_*
   • SDS_*
3. Configure a replication connection for the new target database.
   • If your new target database is of the same type as your old target database, then simply edit your existing replication connection and update the connection details.

     In the Connections page, locate the replication connection, click Inspect, and use the General tab to update the details for the new target database.

   • If your new target database is of a different type, then create a new replication connection for that type and specify the connection details.

     Click Create, then Replication Connection, select the appropriate type, and specify the details.

4. Update each data replication entry that is configured to use the old target database connection details.
   1. Open the Data Replications page, and select the data replication you want to edit.
   2. In the Replication Target area:
      • If your new target database is of the same type as your old target database, make sure that Schema is set correctly for the new database.
      • If your new target database is of a different type, click Select and select the new target connection, then click Schema and set correctly for the new database.
5. From the Home page, navigate to Data and then Connections. Locate the replication connection for your target database, click Inspect, and use the Tables tab to verify the table information for the new target schema.

You can now resume data replication in incremental mode into the new database.