I’m trying to create a synonym in Schema1 for tables which are in Schema2.
But although the synonym is successfully created, I’m getting table or view does not exist.
Immediate suggestions are highly appreciated!!

create synonym ABC for Schema1.ABC;

select * from ABC
table or view does not exist