Database Administration (MOSC)

MOSC Banner

Data not populating through Other Schema

edited May 6, 2016 5:04AM in Database Administration (MOSC) 11 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center