Data not populating through Other Schema
Issue is : the synonym of other schema unable to populate data from the schema owner.
Like the Schema owner is RMS14DEV and tha view table name is V_ITEM_MASTER. This table contains more than 100 data.
Now another schema is RMS_INTG.
I have created synonym as per below:
CREATE SYNONYM "V_ITEM_MASTER" FOR "RMS14DEV"."V_ITEM_MASTER";
then try to select data from RMS_INTG user and I do not get any data through the below query:
select * from V_ITEM_MASTER; [ Result : No rows selected ]
I have tried using public synonym also and got the same result.