Schema Compare has been used numerous times in the past to perform comparisons between two databases. In the recent compares, Scheme Compare does not find any table in Target schema and hence comparison results are incorrect. Schema Compare options have not been altered.
RESOLUTION 1:
1) Close Toad for Oracle.
2) For Windows XP - Go to 'C:\Documents and Settings\<OS_USER>>\Application Data\Quest Software\Toad for Oracle\<Toad Version>\User Files' directory.
or
For Windows Vista and 7 - Go to 'C:\Users\<OS USER>\AppData\Roaming\Quest Software\Toad for Oracle\<Toad Version>\User Files' directory.
(a) Rename the ToadActions.dat file to ToadActions.dat.backup.
(b) Rename the ToadActions.log to ToadActions.log.backup
3) Launch Toad and test issue.
4. Reopen Toad, and open Schema Compare window. Re-enter previous options and execute compare.
RESOLUTION 2:
1. In Toad, select database | Spool SQL | Spool SQL to Screen menu option
2. An Output tab will appear at the bottom-left corner of screen
3. Rerun the compare
4. Expand Output pane which will show all background queries performed by Toad for the compare
5. Locate any "ORA" error in this output. If the following error is found then the tablespace used needs to be extended:
Error: ORA-01652: unable to extend temp segment by 64 in tablespace TABLESPACE
6. For any other "ORA" errors, copy the SQL statement resulting in error in SQLPlus or Toad's Editor to execute manually in order to reproduce the error and report to DBA
RESOLUTION 3:
Uninstalled Toad for Oracle 32-bit and installed 64-bit.
STATUS
Waiting for fix in a future release of Toad for Oracle
