Have an Oracle Installation on (for example) 10.30.1.108 (Schema A)
and another on Oracle Installation on 10.30.1.110. (Schema B).
Need to compare some tables BY VALUES from Schema A and Schema B
using the Query Browser ONLY.
Can connect to Schema A and Schema B, as soon as I drag one table from
Schema A, select one table with the fields I need to compare to Schema B, when
I connect to Schema B, a new Object Pallet opens and I can’t drag and drop
tables across Query Browsers.
Using Xpert Edition 18.104.22.168.
The Compare function does not work - four hours to compare the contents of one field in a tiny 1,000 row table.
Need an SQL based solution as I am very familiar with SQL, but (clearly) not TOAD.
Our Gov. Agency just purchased two licensed Oracle Xpert TOAD versions, so we are not getting any more TOAD products any time soon.