My Oracle Support Banner

ORA-942 when tables exist of same name in multiple schemas (Doc ID 1377991.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms


Queries return error:
ORA-00942: table or view does not exist

Also, tables exist of same name in multiple schemas.


Example:

select owner,object_name,SUBOBJECT_NAME,object_type from dba_objects
where
object_name='<TABLE_NAME>'


OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_TYP
---------- -------------------- ------------------------------ ----------
H1 <TABLE_NAME> TABLE
R1 <TABLE_NAME> TABLE
R2 <TABLE_NAME> TABLE
W1 <TABLE_NAME> TABLE
P2 <TABLE_NAME> TABLE
...
A1 <TABLE_NAME> TABLE
A2 <TABLE_NAME> TABLE

137 rows selected




Changes

 

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
Changes
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.