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

NMP-00007: I/O failure

1 Answers  


ORA-19815: WARNING: string of string bytes is string used, and has string remaining bytes available.

1 Answers  


ORA-15108: missing or invalid template name

1 Answers  


ORA-09981: skxfqdreg: Error Adding a page to the SDI buffer pool

1 Answers  


RMAN-03008: error while performing automatic resync of recovery catalog

1 Answers   HCL,






ORA-31084: error while creating table "string"."string" for element "string"

1 Answers  


PLS-01425: Connect-by clause

1 Answers  


ORA-27023: skgfqsbi: media manager protocol error

1 Answers  


ORA-02060: select for update specified a join of distributed tables

1 Answers  


ORA-13459: GeoRaster metadata SRS error

1 Answers  


RMAN-01007: at line number column number file: string

1 Answers  


RMAN-06106: this command requires that target database be mounted

1 Answers  


Categories