My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
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='HNT'


OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_TYP
---------- -------------------- ------------------------------ ----------
H1 HNT TABLE
R1 HNT TABLE
R2 HNT TABLE
W1 HNT TABLE
P2 HNT TABLE
...
A1 HNT TABLE
A2 HNT TABLE

137 rows selected




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.