Error "ORA-00942: table or view does not exist" when starting up (48289)

  • Title

    Error "ORA-00942: table or view does not exist" when starting up
  • Description

    Installed the repository into schema name 'TOAD'. When launching Code Tester and logging in as another user, getting the following exception error:

    exception message : ORA-00942: table or view does not exist ORA-06512: at "TOAD.QU_HARNESS_XP", line 4355 ORA-06512: at line 3.

    main thread ($7b0):
    005926c6 QuestCodeTesterOracle.exe Oracle RaiseOracleError
    0059bfc7 QuestCodeTesterOracle.exe Oracle TOracleQuery.RaiseException
    0059ca70 QuestCodeTesterOracle.exe Oracle TOracleQuery.InternalExecute
    0059d056 QuestCodeTesterOracle.exe Oracle TOracleQuery.ExecuteArray
    0059cf61 QuestCodeTesterOracle.exe Oracle TOracleQuery.Execute
    00791cbe QuestCodeTesterOracle.exe QU_HARNESS_XP 2455 QU_HARNESS_XP_N_ALLROWS_FILTERED_TE_CV
    00d21480 QuestCodeTesterOracle.exe uTHarness 1430 TColHarness.Refresh
    00d215d3 QuestCodeTesterOracle.exe uTHarness 1451 TColHarness.Refresh
    00d132ad QuestCodeTesterOracle.exe dm_UTmain 921 TdmUTmain.Login
    00cd1777 QuestCodeTesterOracle.exe frm_TestManager 1943 TfrmTestManager.DoConnect
    00cce793 QuestCodeTesterOracle.exe frm_TestManager 983 TfrmTestManager.ProcessCommandLine
    00cce4d3 QuestCodeTesterOracle.exe frm_TestManager 916 TfrmTestManager.WMAfterStartup
    004d7b7b QuestCodeTesterOracle.exe Controls TControl.WndProc

  • Cause

    Option 'Create Public Synonyms after installation' was not selected when installing the repository into schema 'TOAD'

  • Resolution

    To create the necessary public synonyms:

    1. Start | All Programs | Quest Software | Quest Code Tester for Oracle | Administration | Repository Manager | select 'Provide Instance-wide Access to repository Manager | Next
    2. Enter the Schema name, password & database where the repository is installed | Next

Feedback submitted.

Did this article help?

[Select Rating]

Thank you for your rating!


Request or Create a KB Article »

Code Tester for Oracle
1.8.6, 1.8.5, 1.8.4, 1.8.3, 1.8.2, 1.8.1, 1.8.0, 1.6.1, 1.6.0, 1.5.3, 1.5.2, 1.5.1


Article History:
Created on: 11/11/2008
Last Update on: 2/10/2010