ORA-942 when tables exist of same name in multiple schemas
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
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