Showing posts with label ORA-12046. Show all posts
Showing posts with label ORA-12046. Show all posts

Thursday, 16 February 2012

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

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

Cause: REFRESH USING TRUSTED CONSTRAINTS specified in ALTER MATERIALIZED VIEW or CREATE MATERIALIZED VIEW of a remote materialized view

Action: remove this attribute from ALTER or CREATE MATERIALIZED VIEW DDL