Return
-
Title
Out of memory exception running data compare on very large tables -
Description
When trying to compare tables between a SQL Server and Oracle environment, the job is not completed and either fails with an out of memory exception or starts a continuous loop during the compare. This issue occurs when the tables being compared are in the region of 200GB - 300GB per table with about 1.2 bil records in each table.
-
Cause
Issue was caused by 32-bit platform limitations. -
Resolution
WORKAROUND:
None.
STATUS:Issue fixed in version 4.1. The latest version of Toad Data Point can be downloaded here.
-
Defect ID
QAT-6824