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

TNS-00515: Connect failed because target host or object does not exist

1 Answers  


LSX-00011: internal error: ~s

1 Answers  


ORA-02479: error while translating file name for parallel load

1 Answers  


SQL-02130: EXEC TOOLS interface is not available.

1 Answers  


ORA-07489: scgrcl: cannot get lock status.

1 Answers  






ORA-14276: EXCHANGE SUBPARTITION requires a non-partitioned, non-clustered table

1 Answers  


ORA-12477: greatest lower bound resulted in an invalid OS label

1 Answers  


ORA-29513: referenced class name too long

1 Answers  


ORA-01554: out of transaction slots in transaction tables

1 Answers  


ORA-36274: (XSCGMDLAGG05) The operator used in this equation needs a weight variable.

1 Answers  


ORA-27458: A program of type PLSQL_BLOCK cannot have any arguments.

1 Answers  


TNS-12602: TNS: Connection Pooling limit reached

1 Answers  


Categories