My Oracle Support Banner

ORA-00942 When Updating Table In Oracle Server 11g Using JDBC Drivers (Doc ID 1211614.1)

Last updated on AUGUST 30, 2023

Applies to:

JDBC - Version 11.1.0.7 and later
Information in this document applies to any platform.

Symptoms

Application using JDBC 10g or JDBC 11g drivers against Oracle Server 11g (11.1.0.7 or 11.2.0.1) fails intermittently on update with error:

ORA-00942 Table or View does not exist

This error occurs even though the user account (application login account) has full access to tables.
This is an environment where multiple schemas have identical objects; different schemas contain the tables updated.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.