Create public synonym fails with error ORA-38818
(Doc ID 2758854.1)
Last updated on MARCH 15, 2021
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
We cannot create a synonym for view but appear with error: ORA-38818
CREATE PUBLIC SYNONYM XYZ_VIEW FOR SCOTT.XYZ_VIEW
ERROR in line 1:
ORA-38818: reference not valid to the object with SCOTT edition.XYZ_VIEW
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