Database on A server, want to on server B generated on A server view some tables in the database, for others to connect server access to view data, B
How to do?

CodePudding user response:

Why there is no data link access?

CodePudding user response:

In addition can also build synonyms

CodePudding user response:

1, set up between the two databases dblink
2, establish A synonym or view on B server

CodePudding user response:

View, establish dblink do,

If two different networks, database access do materialized views too slow