ORA-942 when tables exist of same name in multiple schemas

(Doc ID 1377991.1)

Last updated on DECEMBER 15, 2014

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms