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

ORA-39754: FULL PARTITIONED OUTER JOIN is not supported

1 Answers  


ORA-09980: skxfqdrcv: Error Receiving a message from another endpoint

1 Answers  


ORA-32013: failure in verifying parameters from the restored SPFILE

1 Answers  


SQL*Loader-00111: Invalid number of rows for bind array or data saves

1 Answers  


NNL-00897: Messages sent: number

1 Answers  






NNL-00012: invalid "string" value "string"

1 Answers  


ORA-10919: Default temporary tablespace group must have at least one tablespace

1 Answers  


ORA-03233: unable to extend table string.string subpartition string by string in tablespace string

1 Answers  


AMD-00119: analytic workspace dimensions not specified in input

1 Answers  


ORA-12209: TNS:encountered uninitialized global

1 Answers  


DRG-10852: Invalid scoring type string specified for query template

1 Answers  


PLS-00160: AUTHID must specify CURRENT_USER or DEFINER

1 Answers  


Categories