When running a schema compare with many tables, e.g. 350, the following error appears and Toad crashes:
"The statement is too long or too complex"
With fewer tables, the compare works fine.
Increase the statement heap size: STMTHEAP, to 8192, then retest the schema compare.
Defect ID ST99577 has been submitted for this issue in version 5.0.3. In this case a Schema Compare which works in version 4.7 will fail with the above error in 5.0.3. The workaround is above.
