Database Tuning (MOSC)

MOSC Banner

Spurious ORA-00942: table or view does not exist

edited Jul 21, 2010 6:19PM in Database Tuning (MOSC) 8 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center