Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-23309: object string.string of type string exists

1 Answers  


ORA-09857: smprset: vm_protect error while protecting pga.

1 Answers  


ORA-28025: missing or null external name

1 Answers  


ORA-09318: slkhst: unable to host out to operating system

1 Answers  


ORA-31021: Element definition not found

1 Answers  






ORA-19645: datafile string: incremental-start SCN is prior to creation SCN string

1 Answers  


SQL*Loader-00503: Error appending extension to file (string)

1 Answers  


ORA-09813: Unable to get directory status

1 Answers  


ORA-01412: zero length not allowed for this datatype

1 Answers  


ORA-24024: Internal error in DBMS_AQ_IMP_INTERNAL.string [string] [string]

1 Answers  


QSM-02044: ORDER BY clause in mv

1 Answers  


QSM-02069: PCT not supported with multi-column partition key

1 Answers  






Categories