#811 ORA-00942: table or view does not exist


After connecting to Oracle 11g, a simple SQL statement almost always fails in the first worksheet with 'ORA-00942: table or view does not exist', and the cursor placed directly in from of the table name. If I click the 'Describe under cursor', the table details are retrieved and displayed correctly. Trying to execute the query again results in the same error.

If I then open a second worksheet, and run 'select * from dual;', the initial SQL statement in the first worksheet executes correctly.
Or if I then change the schema from the automatically selected schema to a different one, and set the dropdown to the original schema, and then run the query, it will execute correctly.
If my first query is 'select * from dual', or 'select * from user_objects', the result is as expected, but querying a table in the schema still fails.

Tora trunk, compiled on Ubuntu Lucid with gcc 4, Qt 4, etc. Oracle Instant Client 11.2


  • Ivan Brezina

    Ivan Brezina - 2013-10-26
    • status: open --> closed-fixed
    • Group: -->
  • Ivan Brezina

    Ivan Brezina - 2013-10-26

    Should be fixed in Tora 3 alpha


Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks