Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
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.
