Re: bitmap join index error

From: Misha Ageev <ageev_at_mail.cir.ru>
Date: 15 Jul 2003 03:47:39 -0700
Message-ID: <877c3c6c.0307150247.71bfd6d6@posting.google.com>

I have tried to create all possible UNIQUE constraints, but the error remains the same:

delete from ma14_doc_feats;
insert into ma14_doc_feats(doc_id, feat_id) values(1, 1001);
insert into ma14_doc_feats(doc_id, feat_id) values(2, 1002);
insert into ma14_doc_feats(doc_id, feat_id) values(3, 1003);

commit;
create unique index ma14_dfi_doc_id_un on ma14_doc_feats(doc_id); create unique index ma14_dfi_feat_id_un on ma14_doc_feats(feat_id);

SQL> create bitmap index ma14_doc_feats_bitmap1   2 on ma14_feats(d.doc_id)
  3 from ma14_feats f, ma14_docs d, ma14_doc_feats dfi   4 where f.feat_id=dfi.feat_id
  5 and d.doc_id=dfi.doc_id;
  from ma14_feats f, ma14_docs d, ma14_doc_feats dfi

                     *

ERROR at line 3:
ORA-25954: missing primary key or unique constraint on dimension

My version of Oracle is Oracle9i Enterprise Edition Release 9.2.0.1.0

Misha. Received on Tue Jul 15 2003 - 05:47:39 CDT