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



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

Answer / guest

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/ CREATE
MATERIALIZED VIEW DDL

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25236: buffer too small for user data

1 Answers  


NNO-00702: cache checkpointing disabled

1 Answers  


ORA-12564: TNS:connection refused

1 Answers  


ORA-16546: missing or invalid piece

1 Answers  


ORA-13643: The task can not be interrupted or cancelled.

1 Answers  






NZE-28769: Specified method does not exist.

1 Answers  


PROT-00303: Dump file already exists

1 Answers  


ORA-24346: cannot execute without binding variables

1 Answers  


TNS-12571: TNS:packet writer failure

1 Answers  


ORA-13857: Invalid module name

1 Answers  


NNO-00119: line string: server not authoritative for name "string", data ignored

1 Answers  


ORA-29702: error occurred in Cluster Group Service operation

1 Answers  


Categories