I am using Toad 12.8 and the Database Compare Schema feature and its finding lots of false differences when comparing schema between an Oracle 126.96.36.199.0 and 188.8.131.52.0 database. In particular relating to:
- Table definition - “NO INMEMORY”.
- Comments - LOB storage specs (not really comments but table comments being parse wrong).
- Triggers - “description column of dba_triggers” or “schema specification in description column of dba_triggers” in “Differs By” but not differences when check.
While none of these are show stoppers, it does cause quite a bit of pain as one have to check each of the differences to make sure that they are not “real” differences.
Am I doing something wrong hear? Is there a work around for this or is this a bug in Toad?
specification in description column of dba_triggers