I have two instances of the same database which started off being identical. I ran a different version of the same code in each instance. I now want to compare particular database tables in each instance to check for different values. This is the first time I’ve tried this since installing Toad For Oracle Base 220.127.116.11
I’m having 2 issues:
One of the tables I want to compare has c. 3.5 million rows. When I try to compare these I’m getting an error in Toad saying it is out of memory. Any way around that?
Because of the above I just wanted to see if I could run it for a small subset. I was able to include a where clause so that only 35 records would be returned on each side and there should be differences. This ran and I can see on the Differences tab of the Compare Results it is showing a figure of 2. However when I select the tab I’m just seeing empty box. No data displayed. Have gone through setttings to see if anything missing but couldn’t find anything so any help would be greatly appreciated.