Web Development



Create synonym on target system for accessing data on source system

By kittielemieux ·
On source system, I created a view of a table that exists on that instance, just in a different schema. The view was created in schema called dwadmin. If I describe dwadmin.table on source system, looks great.

On the target system, I tried to create a synonym but I obviously did it wrong because my insert is coming up empty. The schema on the target system is also called dwadmin. So how does the FROM statement in my query know to pull from the schema on the source system?

It must be related to how I created the synonym but that is where I am stuck...

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums