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

PCC-00137: Invalid use of SQL cursor host variable

1 Answers  


ORA-12696: Double Encryption Turned On, login disallowed

1 Answers  


ORA-09771: osnmwrtbrkmsg: bad return code from msg_send.

1 Answers  


SQL-02131: Runtime context in use

2 Answers  


RMAN-08529: proxy file handle=string

1 Answers  






ORA-14306: List value 'string' specified twice in partitions 'string', 'string'

1 Answers  


ORA-00703: maximum number of row cache instance locks exceeded

1 Answers  


LFI-00111: No other flags allowed in fixed length format.

1 Answers  


PLS-00434: record field has unsupported type: "string"

1 Answers  


LPX-00011: In line ~1u of ~2s [general entity ~3S]:

1 Answers  


ORA-07267: spwat: invalid process number.

1 Answers  


ORA-36378: (XSAGTHRWEIGHT) While running AGGREGATE with multiple threads, the weight variable workspace object specified by your ARGS variable workspace object must exist in the same analytic workspace as your AGGMAP workspace object.

1 Answers  


Categories