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