Oracle Database Error Code ORA-12071 Description :
definition query of “string”.”string” is invalid for offline instantiation
Error Cause:
Offline instantiation requires materialized view definition queries to observe the following constraints: o 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. o All master tables referenced must be located at the local site. References to other sites are not allowed.
How to Solve :
Modify the materialized view definition query.
Search Oracle Error Codes and Descriptions:
Be The First To Comment
Similar Errors
Please Leave Your Comments Below