Return
-
Title
Error optimizing query using SYSDBA account: "ORA-01422” -
Description
The following error occurs when optimizing any query in SQL Optimizer connected to database as SYSDBA:
"Oracle error - ORA-01422: exact fetch returns more than requested number of rows" -
Resolution
WORKAROUND:
Make a new connection and connect as NORMAL.STATUS:
Waiting for fix to be released in a future version of SQL Optimizer for Oracle. -
Defect ID
CRNeeded