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

DRG-12306: column string is too long for index set columns

1 Answers  


NNL-01007: VERSION SKEW responses received: number

1 Answers  


ORA-30017: segment 'string' is not supported in string Undo Management mode

1 Answers  


ORA-36637: (XSDUNION05) The concat dimension cannot be defined as UNIQUE because it has a non-unique concat base dimension workspace object.

1 Answers  


ORA-19813: cannot have unavailable file string in DB_RECOVERY_FILE_DEST

1 Answers  






PLS-00424: RPC defaults cannot include Package State

1 Answers  


ORA-01639: instance string has no thread assigned to it

1 Answers  


ORA-14511: cannot perform operation on a partitioned object

1 Answers  


ORA-32842: value for property string cannot be altered

1 Answers  


NNL-00520: Changes an existing name's TTL

1 Answers  


RMAN-06588: number of patterns (number) to DB_FILE_NAME_CONVERT should be even

1 Answers  


ORA-24120: invalid string parameter passed to DBMS_REPAIR.string procedure

1 Answers  


Categories