Compare Data, on two views, does not return results and has ORA-01446 error in Spool SQL
説明
When using Compare Data for two views, it runs for several hours and never returns. When doing a Spool SQL on the compare, the following errow was found.
ORA-01446: cannot select ROWID from, or sample, a view with DISTINCT, GROUP BY, etc.
対策
WORKAROUND:
Selected some key columns for the view on the "Select columns" step. Toad will check to see if the key columns are unique.
STATUS:
Waiting for a fix to be released in a future version of Toad for Oracle.
