Oracle database through the link connection after used, create materialized views make it automatically refresh, but automatically refresh the need to create a log file, but essentially a database created in Oracle remote log files, prompt "ORA - 00949: illegal reference remote database", this kind of situation to the materialized views automatically refresh what to do,
Please give me a solution,

CodePudding user response:

The data synchronization with database synchronization tool, and then do the materialized views;


PS: it could be ORACLE would think that the stability of the remote database is not strong;

CodePudding user response:

to help