Oracle Database 12c New Features

ORA-12071: definition query of string.string is invalid for offline instantiation

ORA-12071: definition query of "string"."string" is invalid for offline instantiation


Cause:


Offline instantiation requires materialized view definition queries to observe the following constraints:
* The database link that will be used by the materialized view site to connect to the master site must be included with each master table referenced in the query.
* All master tables referenced must be located at the local site. References to other sites are not allowed.



Action:


Modify the materialized view definition query.