Prior to registering a Compare Source environment, the following database relationships must be configured by your implementation's database administrator to match the diagram below:
Notice that there is no database relationship originating from the Compare Source schema back to the target environment's schema. This is because random keys added in a Compare Source are not kept in the target environment's key table (because the system does not guarantee unique keys between a Compare Source and a target environment).
The diagram below shows how the script table in a Compare Source environment's database is accessed by the target environment using a remote table synonym, prefixed with "R" in this case:
Copyright © 2000, 2015, Oracle and/or its affiliates. All rights reserved. Documentation build: 2.19.2015 16:18:51 [F1_1424305131000]