1

I have application / service which connects to Oracle database (11g) which shows me "ORA-00942: table or view does not exist" in its log file without any indication of particular table/view with which it has problem. And there is no way on app side to increase log details to include this data.

I have direct access to the Oracle database which is using by this app (not DBA level privileges, but quite high level of access) any advice on how to check with which table or view my app having issue? Probably I can use some query to check this? I'd like to find out object name so that I can check granted access and any locks on it.

  • The best way to do this is to use a login trigger to enable session tracing for the specific user in question – Philᵀᴹ Mar 31 '14 at 15:54
  • Wild guess (without much data to work on) but see if you have XDB option installed in your db and if it is in valid state. if not, you will need to install it. There are so many reasons you would get the error, but check this as well. – Raj Apr 1 '14 at 18:51
1

If you enable tracing for this specific error, a session trace file will be generated whenever it occurs. This will allow you to view the SQL that causes the error. You will probably need the cooperation of your DBA to do this, as it's likely only they will be able to activate the trace and access the trace dump directory.

Here's a link showing how to do this:

http://oracle.erkansaka.org/2011/09/how-to-trace-oracle-error.html

So for you that would be:

alter system set events '942 trace name errorstack level 1';

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.