This discussion is archived
2 Replies Latest reply: Apr 24, 2013 12:47 PM by 1005272 RSS

ORA-00942: table or view does not exist

1005272 Newbie
Currently Being Moderated

when I start to write a query in a 'Sql File' I receive the error ORA-00942 in a alert dialog for every letter I write.
For exemple: I want to write the query "select * from User", when I write the letter 's' the alert dialog with the error appears. Then I press OK and write the letter 'e' and again the alert dialog appears. This is happening for every letter I write.

How can I fix this?

  • 1. Re: ORA-00942: table or view does not exist
    Gary Graham Expert
    Currently Being Moderated

    Welcome to the forum!

    That behavior is completely "off-the-wall". You do not provide any background information to help anyone who cares to respond. For example, the SQL Developer version in use, database you are connecting to, third-party extensions you may have installed, etc.

    If you just installed the latest production version ( into a empty directory, had no prior version to migrate settings from, and connect to an Oracle database, then the behavior (with Tools -> Preferences -> Code Editor -> Completion Insight on by default) when typing "select * from u" should be to pop-up a list of possible table/view names to select from.

    Please post additional details if you want help.

  • 2. Re: ORA-00942: table or view does not exist
    1005272 Newbie
    Currently Being Moderated
    Thanks Gary!

    I changed the behavior of Completion Insight increasing the velocity of Pop-up.

    Before it was configured to 0,3 seconds. But it seems strange to me, because I think that the auto-complete should not try to put a table name when I typing a 'select'.

    But anyway, it works for me.

    Now configure Completion Insight with 3 seconds and I have enough time to write the queries without the Pop-up appears for every letter.



  • Correct Answers - 10 points
  • Helpful Answers - 5 points