QSM-02173: the unique constraints does not exist on the join
columns of the inner table



QSM-02173: the unique constraints does not exist on the join columns of the inner table..

Answer / guest

Cause: If there are outer joins, unique constraints must
exist on the join columns of the inner table. Othwerwise,
the materialized view can not be fast refreshable.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-29390: some resource plans are not part of any top-plan

1 Answers  


ORA-27474: cannot give both an argument name and an argument position

1 Answers  


ORA-23534: missing column in materialized view container table "string"."string"

1 Answers  


ORA-36810: (XSTBLFUNC05) Analytic workspace object number does not exist.

1 Answers  


NNC-00428: invalid meta-data data item

1 Answers  






DRG-50860: failed to prepare statement

1 Answers  


ORA-27203: skgfpqb: sbtpcquerybackup returned error

1 Answers  


TNS-12658: ANO service required but TNS version is incompatible

1 Answers  


ORA-34145: (MXCGPUT03) You cannot use the APPEND keyword with SURROGATE workspace object.

1 Answers  


ORA-04098: trigger 'string.string' is invalid and failed re-validation

1 Answers  


ORA-31454: invalid value string for operation parameter, expecting: ADD or DROP

1 Answers  


ORA-31463: logfile location string is an empty directory

1 Answers  


Categories