Return
-
Title
Compare schema shows differences in objects even though there are none -
Description
When doing a compare schema, Toad returns some objects as having differences, even though there are not any differences.
-
Resolution
In the Object Type Specific Options tab in the Options tab of the Compare Schema window, check the following options:
Exclude Whitespace
Exclude Code Comments
Ignore Case
Other options may need to be checked to have Toad see no differences in the objects, but these three are the most common.