Merging allows you to upload changes you have made in the Oracle Workspace to the parent table or workspace.
Table Name
This field contains the name of the table that the workspace is based on. This field is read-only.
Current Workspace
This field contains the name of the current workspace, which contains the data you are going to upload to the parent workspace. This field is read-only.
Parent Workspace
This field contains the name of the parent workspace to which you are going to upload data. This field is read-only.
Where Clause
To upload the data from a specific column in the workspace, specify that column in this field.
Conflict Resolution
The next six options pertain to resolving conflicts with existing data. Conflicts result when you are trying to upload data to a parent workspace that has multiple values for the same data. Workspaces preserve the original value (the Base Value) and the most recent change to the row. When you upload information to a row with two existing values, it is important to indicate which value should be maintained in the workspace.
Show Each Conflict
Click this button to display each conflict and resolve it individually.
Stop if any Conflicts Exist
Click this button to end the merge process if conflicts are encountered.
Automatically Process Conflicts
Click this button to process all conflicts the same way according to the options below:
Use Value from Current Workspace
Click this button to replace the most recent change in the parent workspace with the value from the current workspace.
Use Value from Parent Workspace
Click this button to leave the most recent change in the parent workspace in place.
Revert to Base Value
Click this button to revert to the original (Base) values in the parent workspace. In this case the base rows are copied to the child workspace but not to the parent workspace. The conflict is considered resolved because the child workspace and the parent workspace are in sync. When the child workspace is merged, the base rows are copied to the parent workspace too.
Remove Data from Current Workspace
Select this check box to remove the data specified in the Where Clause field from the current workspace. You can only select this option if the current workspace itself has no children workspaces beneath it. This check box is disabled if the current workspace has child workspaces. This option is cleared by default.
Navigation Buttons
OK
Click OK to begin the merge process.
Cancel
Click Cancel to abandon the merge process.
See also: