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-12669: Shared server: outbound protocol does not support proxies

1 Answers  


NNF-00001: Not a TNS address

1 Answers  


ORA-03278: duplicate ALLOCATE EXTENT option specification

1 Answers  


ORA-22984: view query cannot contain references to a super view

1 Answers  


ORA-14642: Bitmap index mismatch for tables in ALTER TABLE EXCHANGE PARTITION

1 Answers  






NPL-00312: attempt to put ASN.1 "UNIV" type with illegal tag string

1 Answers  


ORA-24904: invalid callback attribute passed into OCI call

1 Answers  


ORA-31693: Table data object string failed to load/unload and is being skipped due to error: string

1 Answers  


LFI-01504: fseek() failed(OSD return value = string) in string.

1 Answers  


ORA-22164: delete element operation is not allowed for variable-length array

1 Answers  


ORA-12686: Invalid command specified for a service

1 Answers  


DRG-11216: length of datastore data exceeds limit

1 Answers  


Categories