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