Configure a Data Distribution Topology
-
Add a data replication environment where the source PDB has an Extract process that captures from the source PDB and transmits trail data to the intermediate PDB which contains a Replicat and an Extract process. On the intermediate instance, the Replicat applies the trail data from source PDB and then the Extract captures the committed transactions and trasmits trail data to the target PDB. See Data Distribution for a conceptual understanding of this type of topology.
-
Add DML transactions on the source PDB to observe how Extract captures data and writes to trail.
-
Check the statistical reports for Daily, Hourly, and Total committed DML and DDL operations.
-
Delete the data replication environment and verify that the environment was deleted after testing.