对ORA-00942进行故障排除 [英] Troubleshooting ORA-00942

问题描述

在昨晚的一次自动化测试中，我的二十个工作线程中的一个爆裂了.该应用程序正在尝试插入. Springframework报告ORA-00942:表或视图不存在.

In the middle of an automated test run last night, one of my twenty worker threads blew out; the application was attempting an INSERT. Springframework reports ORA-00942: table or view does not exist.

通过企业管理器连接到数据库(11.1.0.6.0)，我拉出一个SQL工作表并查询该表，发现(a)该表现在存在(b)应该插入的行是缺少(c)此线程先前插入的行存在(d)该表在时间错误前后都有行.

Connecting to the database (11.1.0.6.0) through the enterprise manager, I pull up a SQL worksheet and query the table, discovering (a) that the table exists now (b) the row that should have been inserted is missing (c) the row previously inserted by this thread is present (d) that the table has rows before and after the error in time.

对于没有oracle经验的用户，我如何验证错误是由该数据库服务器引起的，以及如何从那里将错误带回根本原因?

For a user with little oracle experience, how do I verify that the error originated with this database server, and from there how do I walk the error back to a root cause?

推荐答案

正如Dave K所说，表可能已经存在，但在您的过程中变得不可见".

As Dave K said, the table may have existed, but became "invisible" to your process.

由于使用了昨晚"一词，我的想法是可能有一个每晚的过程，例如备份或清理过程，导致该表脱机.

Because of the phrase "last night", my thoughts lead that there may be a nightly process, like a backup or clean-up process, which caused the table to be taken offline.

这篇关于对ORA-00942进行故障排除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！