OWB Synchronization in Code Samples
By David Allan-Oracle on Oct 01, 2010
The OWB synchronization expert to update sets of dependencies in a simple manner has been uploaded into the code sharing area here. The expert lets you update dependent objects in a quicker manner than going one by one in the designer.
After importing the MDL you can apply the experts (one to list dependencies, the other to synchronize dependencies) to object types. For example you can apply to tables, pluggable mappings, then if you change the table and want to synchronize all usages, you can right click on the object and select 'Synchronize to Dependents.
This will then display all dependent usages of the object, where you can decide which ones to synchronize and how.
Select the objects and OK, this will for example here ensure the mappings where this table is used are in synch with the table definition itself. You will then get a conformation dialog indicating it has finished.
This useful utility is a simple sample expert built on the OMB primitives and is in the code sample area, so you can take, enhance and change...and upload if you want to donate in the sample area for others. There is another expert in the MDL file that simply lists the dependencies, not all object types are supported but many of the common ones are (relational object definitions and mappings/pluggable mappings).