Re: bitmap join index error

From: Misha Ageev <ageev_at_mail.cir.ru>
Date: 15 Jul 2003 03:52:01 -0700
Message-ID: <877c3c6c.0307150252.70771083@posting.google.com>

I have already read this docs, and it does not explain the problem. All dimension tables (ma14_docs and ma14_feats) already have primary keys on columns I used.

Misha

danielroy10junk_at_hotmail.com (Daniel Roy) wrote in message news:<3722db.0307141702.6cab90fc_at_posting.google.com>...
> From Oracle:
>
> ORA-25954 missing primary key or unique constraint on dimension
>
> 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.
>
> Daniel
Received on Tue Jul 15 2003 - 05:52:01 CDT