Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
    
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 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 at 18:51

1 Answer 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';
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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