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-26097: unsupported conversion for column string (from type number to type number)

1 Answers  


ORA-29887: cannot support row movement if domain index defined on table

1 Answers  


QSM-01107: Partition Containment Tracking (PCT) rewrite is not allowed

1 Answers  


ORA-00601: cleanup lock conflict

1 Answers  


ORA-38482: no elementary attributes defined in the attribute set

1 Answers  


ORA-06955: Number of database servers exceed limit

1 Answers  


ORA-33223: (CMOVE03) You cannot move a session-only dimension value.

1 Answers  


RMAN-20310: proxy copy not found in the recovery catalog

1 Answers  


ORA-24323: value not allowed

1 Answers  


RMAN-10029: unexpected return code number from PL/SQL execution

1 Answers  


TNS-00017: INTCTL: error while performing NS receive command

1 Answers  


RMAN-08522: input datafile fno=string name=string

1 Answers  


Categories