Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

NZE-29245: the toolkit does not recognize the function being used

1 Answers  


ORA-14166: missing INTO keyword

1 Answers  


PLS-00327: "string" is not in SQL scope here

1 Answers  


IMG-00821: area N queue clear failed

1 Answers  


ORA-38453: ExpFilter index should be created in the same schema as the base table.

1 Answers  






NZE-29105: Cannot export PKCS #12 wallet.

1 Answers  


ORA-25136: this cluster can contain only one table

1 Answers  


ORA-02213: duplicate PCTUSED option specification

1 Answers  


SQL-02120: First and second arguments to SQLRCN both null

1 Answers  


NNL-01003: NON LEAF responses received: number

1 Answers  


ORA-24160: name string already exists in the name value pair list

1 Answers  


RMAN-06010: error while looking up datafile: string

1 Answers  






Categories