Hot answers tagged

2

A fast refresh would copy incremental changes over the network but requires that a materialized view log be created on the master site on the source table. That adds some overhead to the inserts happening on the master table but would generally make the refresh more efficient. A complete refresh would copy every row over the network every time the ...


1

What about remote database side, what does it have to do? There must have Oracle Net installed on both local and remote database servers. And the user being used should have CREATE SESSION system privilege on the remote database. On fixed user link, local database need to know ID and password set. Is the ID is a usual account with which someone can ...



Only top voted, non community-wiki answers of a minimum length are eligible