Oracle DBA and beyond; these are practical tips for day to day DBA operation and maintenance; a place where you would come to look for a quick fix for a burning situation. I hope that by sharing all these, we all will become better in what we do. And on the way, I hope to save you some sweat :-)
Tuesday, 15 February 2022
How to enable tracing for ORA-00942: table or view does not exist
Enable the alert :
SQL> alter system set events '00942 trace name errorstack level 1';
Disable the alert:
SQL> alter system set events '00942 trace name context off';
No comments:
Post a Comment