Connected to an Oracle database. In the Object Explorer I <right click> tablename | Data Compare. In the Data Compare Wizard, the source schema is populated but when selecting another schema from the same database and connect, the following error occurs:
"cannot load oracle client library occ.dll from home"
Oracle Home was not in the system environment variable 'Path'
With Toad closed add the %Oracle Home%\bin to the beginning of the system environment variable 'Path' i.e.
<right click> | My Computer | Properties | Advanced | Environment Variables | System Variables | Scroll to 'Path' | Edit
Paste, e.g. 'D:\oracle\product\10.2.0\db_1\bin;' at the beginning of the path string.