If you&#39;ve used Oracle, you&#39;ve probably gotten the helpful message &quot;ORA-00942: Table or view does not exist&quot;. Is there a legitimate technical reason the message doesn&#39;t include the name of the missing object? 

Arguments about this being due to security sound like they were crafted by the TSA. If I&#39;m an attacker, I&#39;d know what table I just attempted to exploit, and be able to interpret this unhelpful message easily. If I&#39;m a developer working with a complex join through several layers of application code, it&#39;s often very difficult to tell.

My guess is that when this error was originally implemented, someone neglected to add the object name, and now, people are afraid it will break compatibility to fix it. (Code doing silly things like parsing the error message will be confused if it changes.)

Is there a developer-friendly (as opposed to recruiting your DBA) way to determine the name of the missing table?

---

Although I&#39;ve accepted an answer which is relevant to the topic, it doesn&#39;t really answer my question: *Why isn&#39;t the name part of the error message?* If anyone can come up with the real answer, I&#39;ll be happy to change my vote.

All Ora 00942 Solutions on Gang of Coders

Total of 1 Ora 00942 Solutions

Why doesn't Oracle tell you WHICH table or view does not exist?