Thursday 16 February 2012

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: 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.

Action: Modify the materialized view definition query.

No comments:

Post a Comment