Data compare, by default, maps Oracle tables on two schema by name. To map them manually, click on the "Compare Tables/Views" button on the "Home" tab of the ribbon. On the "Object Compare" dialog window that appears you can first select the Oracle connections and schemas on which the objects reside. When there is a large number of objects you may wish to specify a pattern for the name of the objects you are looking for (ex. all tables that start with a). That will make it easier to find those objects.
In addition to tables, can also compare Oracle views. To do this, check the data comparison option "Compare and Synchronize Views".
 |
Oracle imposes limitations on views and not all views are updatable. Use this option with caution. |
Once you have made your selections, you can click on the "Read Database Objects" link. Data compare will read objects on each schema and populate the two left bottom windows with the list of tables / views available.
Now you can map those objects one at a time irrespective of the object names. Select an object on the left, then select an object on the right and click the left to right "arrow" button to map those two objects.
