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-06562: type of out argument must match type of column or bind variable

1 Answers  


ORA-02066: missing or invalid DISPATCHERS text

1 Answers  


VID-00702: unable to initialize video processing environment

1 Answers  


ORA-16571: Data Guard configuration file creation failure

1 Answers  


ORA-03247: Invalid block number specified

1 Answers  






LSX-00025: unknown group "~S"

1 Answers  


ORA-00367: checksum error in log file header

1 Answers  


ORA-27126: unable to lock shared memory segment in core

1 Answers  


SQL*Loader-00306: Token longer than max allowable length of number chars

1 Answers  


ORA-23451: flavor string already defined for object group "string"."string"

1 Answers  


DBV-00200: Block, dba number, already marked corrupted

1 Answers  


ORA-19703: device command string exceeds maximum length of string

1 Answers  


Categories