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-19330: Type 'string'.'string' not installed. Please install the type before using the CREATE_DBURI operator

1 Answers  


ORA-28112: failed to execute policy function

1 Answers  


ORA-38759: Database must be mounted EXCLUSIVE and not open.

1 Answers  


TNS-00261: Interchange Name Community Link Down Time Remaining (secs)

1 Answers  


ORA-12445: cannot change HIDDEN property of column

1 Answers  






NZE-29120: Cannot export certificate.

1 Answers  


ORA-06022: NETASY: channel open failure

1 Answers  


ORA-36910: (XSAGDNGL47) In AGGMAP workspace object, DYNAMIC MODEL workspace object can only edit the top level of its matching relation hierarchy.

1 Answers  


TNS-00310: Navigator: Failed to start tracing after rereading parameter data

1 Answers  


NNL-00218: Ignoring spurious trailing text "string"

1 Answers  


ORA-36871: (XSFTDSC01) Object string cannot be used to define a column in a LIMITMAP.

1 Answers  


ORA-02181: invalid option to ROLLBACK WORK

1 Answers  


Categories