You are here: Home // Oracle 11g // ORA-12046: cannot use trusted constraints for refreshing remote MV

ORA-12046: cannot use trusted constraints for refreshing remote MV

Posted by Oracle 11g Release 2 on Nov 27, 2005 | Leave a Comment

Cause: REFRESH USING TRUSTED CONSTRAINTS specified in ALTER MATERIALIZED VIEW or CREATE MATERIALIZED VIEW of a remote materialized view See the solution below.

Error solution: remove this attribute from ALTER/ CREATE MATERIALIZED VIEW DDL

Database version: Oracle 11g Release 2 (11.2)

Tags: ,

Leave a Reply

Copyright © 2009 Oracle Error Codes Database. All rights reserved.
Powered by WordPress.
Promotes: tłumacz przysięgły sitemap Piła taśmowa Gadżety reklamowe Poznań backup online