Spurious ORA-00942: table or view does not exist
Our JAVA application, which uses JDBC, inserts rows into a partitioned table that has a LOB column. All indexes on this table are local indexes. We are using Oracle version 11.2.0.1; JDBC version 11.2.0.1.0. The application will insert several million rows into this table, then get the error “ORA-00942: table or view does not exist.” This will happen for a while then the error will go away and it will continue inserting rows into the table. No data is missing from the table.
I have seen this happen when we add new partitions and drop old partitions. Unfortunately, the last time we got this error, we were not doing any maintenance on the partitions.
0