When you compare and merge data objects in the Compare
editor, you can filter and sort the differences.
About this task
Filter differences in the Compare editor to simplify the
view. Objects that are filtered from the comparison do not appear
in the Compare editor.
Sort differences in the Compare editor
to simplify the display of objects in the editor and to make it easier
to find objects with differences.
Restriction: - Exported changes are not affected by filtering or sorting. That
is, all changes are exported even if you have filtered them from the
editor. Sort order is not maintained in the export file.
- Synchronization or merging is not affected by filtering. That
is, delta DDL is generated for all objects, regardless of whether
they are filtered from the editor view.
This feature is available only when you compare
data objects.
Procedure
To filter and sort differences in the Compare editor:
- In the Compare editor, click Filter Configuration
from the Compare editor
toolbar.
- If you do not want to include certain objects in the comparison,
select filtering options. For example, you can select to
filter primary keys out of the comparison.
- If you want to sort the changes, select sorting options. For example, you can select to sort the differences in the Compare
editor in ascending or descending order.
Results
The differences between the data objects that are shown in
the Compare editor are filtered or sorted based on the selections
that you made.