Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

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

None
closed-fixed
nobody
None
5
2013-10-26
2010-07-28
John Vandenberg
No

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

Discussion

  • 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