Oracle® Database 8i | 9i | 10g | 11g | 12c | 18c | 19c Error Codes

Information for Database Error Code ORA-12071: definition query of "[string]"."[string]" is invalid for offline instantiation
Oracle® Database Error ORA-12071313/10

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.

Error Type: ORA

Oracle® Database Error Codes 8i | 9i | 10g | 11g | 12c | 18c | 19c

Record: 1/1

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners

Oracle: Registered trademark of Oracle