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

PLS-00371: at most one declaration for 'string' is permitted in the declaration section

4 Answers  


ORA-26534: collision: tranID number ignored and purged

1 Answers  


ORA-22952: Nested Table equality requires a map method on the element ADT

1 Answers  


ORA-25288: AQ HTTP propagation encountered error, status-code number, string

1 Answers  


O2U-00211: A type without attributes was translated

1 Answers  






ORA-09841: soacon: Name translation failure.

1 Answers  


ORA-27503: IPC error attempting to cancel request

1 Answers  


TNS-00513: Destination host unreachable

1 Answers  


ORA-25110: NOSORT may not be used with a bitmap index

1 Answers  


ORA-36996: (XSRELGID13) Valueset workspace object should be defined over dimension workspace object.

1 Answers  


RMAN-10035: exception raised in RPC: string

1 Answers  


RMAN-08046: channel string: starting compressed full datafile backupset

1 Answers  


Categories