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.
Error when running Oracle User Wizard: "PL/SQL: ORA-00942: table or view does not exist"
설명
I receive PL/SQL errors when using the Oracle User Wizard in Spotlight on one of our databases.
Here is the output:
PACKAGE BODY (Line: 640) PL/SQL: ORA-00942: table or view does not exist
PACKAGE BODY (Line: 639) PL/SQL: SQL Statement ignored
PACKAGE BODY (Line: 645) PL/SQL: ORA-00942: table or view does not exist
PACKAGE BODY (Line: 644) PL/SQL: SQL Statement ignored
PACKAGE BODY (Line: 2524) PL/SQL: ORA-00942: table or view does not exist
PACKAGE BODY (Line: 2523) PL/SQL: SQL Statement ignored
PACKAGE BODY (Line: 2561) PLS-00364: loop index variable 'R1' use is invalid
PACKAGE BODY (Line: 2561) PL/SQL: Statement ignored
** Log opened: 3/20/2009 10:28:04 AM ** PACKAGE BODY (Line: 640) PL/SQL: ORA-00942: table or view does not exist
PACKAGE BODY (Line: 639) PL/SQL: SQL Statement ignored
PACKAGE BODY (Line: 645) PL/SQL: ORA-00942: table or view does not exist
PACKAGE BODY (Line: 644) PL/SQL: SQL Statement ignored
PACKAGE BODY (Line: 2524) PL/SQL: ORA-00942: table or view does not exist
PACKAGE BODY (Line: 2523) PL/SQL: SQL Statement ignored
PACKAGE BODY (Line: 2561) PLS-00364: loop index variable 'R1' use is invalid
PACKAGE BODY (Line: 2561) PL/SQL: Statement ignored
** Log opened: 3/20/2009 10:29:38 AM ** PACKAGE BODY (Line: 640) PL/SQL: ORA-00942: table or view does not exist
PACKAGE BODY (Line: 639) PL/SQL: SQL Statement ignored
PACKAGE BODY (Line: 645) PL/SQL: ORA-00942: table or view does not exist
PACKAGE BODY (Line: 644) PL/SQL: SQL Statement ignored
PACKAGE BODY (Line: 2524) PL/SQL: ORA-00942: table or view does not exist
원인
Missing synonym
해결 방안
This issue can be due to a missing public synonym. To discover which synonym is missing, the user can run the manual installation script and examine the output.
The manual installation script can be found in C:\Program Files\Quest Software\Spotlight\Plug-ins\SoO\OracleScripts along with instructions on what to do.
Note: It may be helpful to run each section of the script one at a time until the error is reproduced.
