I’m trying to compare database objects in two different databases – same version of Oracle, but different character sets. I’m running the comparison through the Schema comparison, against a filtered (but long) list of objects.
Toad seems to think a lot of the views are mismatches, which matches some errors we found independently before I tried using Toad’s schema compare – but Toad seems to think virtually every view is wrong, while our errors seem to be more isolated. I’m having trouble identifying specific differences in views that Toad says are mismatched – they appear to me to be identical.
Here’s the real bug report – in trying to figure out what’s really going on, I did a compare with “Format before comparison” turned on. With that option checked, I can’t get the compare to complete. I get the following error consistently:
Access violation at address 230EF8E3 in module ‘QP5.dll’. Write of address 00000000
Toad 10.6.1.3 (with DB Admin Module) running on Windows 7 Enterprise 64-bit, 6G RAM.
Database is Oracle 10.2.0.4.0