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-18010: command missing mandatory CATEGORY keyword

1 Answers  


ORA-25110: NOSORT may not be used with a bitmap index

1 Answers  


ORA-32008: error while processing parameter update at instance string

1 Answers  


ORA-04079: invalid trigger specification

1 Answers   TCS,


LSX-00143: element "~S" must have type or ref

1 Answers  






LPX-00240: element-start tag is not well formed

1 Answers  


ORA-30378: MV_CAPABILITIES_TABLE is not compatible with Oracle version

1 Answers  


SQL*Loader-00272: Table level OPTIONS statement ignored.

1 Answers  


PLS-00230: OUT and IN OUT formal parameters may not have default expressions

1 Answers  


ORA-23421: job number string is not a job in the job queue

1 Answers   BBC, EDE,


RMAN-06487: changed proxy copy expired

1 Answers  


ORA-24808: streaming of lob data is not allowed when using lob buffering

1 Answers  


Categories