ORA-25954: missing primary key or unique constraint on dimension



ORA-25954: missing primary key or unique constraint on dimension..

Answer / guest

Cause: An attempt to create a join index was made, which
failed because one or more dimensions did not have an
appropriate constraint matching the join conditions.

Action: Ensure that the where clause is correct (contains
all of the constraint columns) and that an enforced
constraint is on each dimension table.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

DRG-12434: connection failed using configuration string information

1 Answers  


ORA-01037: maximum cursor memory exceeded

1 Answers  


PLS-00165: call statement is not supported in PL/SQL

1 Answers  


ORA-23611: tablespace "string" has more than one data file

1 Answers  


ORA-12666: Dedicated server: outbound transport protocol different from inbound

1 Answers  






ORA-27012: skgfrd: read from file failed

1 Answers  


ORA-22891: cannot have multiple columns in REF constraint

1 Answers  


TNS-00127: Missing Connection Manager name in TNSNET.ORA

1 Answers  


IMG-00854: internal image data free failed

1 Answers  


ORA-12612: TNS:connection is busy

1 Answers  


RMAN-06511: RMAN retention policy is set to redundancy number

1 Answers  


AMD-00110: parameter string of "string" not valid

1 Answers  


Categories