RE: possible to have a primary key with a bitmap indx?

2003-09-23 Thread Jacques Kilchoer
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > > is it possible to have a primary key that is enforced with a > bitmap index? I don't think so. Here's an example from a 9.2.0.3 database: SQL> create table t (v varchar2 (10), d d

RE: possible to have a primary key with a bitmap indx?

2003-09-23 Thread Mladen Gogala
Oracle DBA > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Khedr, Waleed > Sent: Tuesday, September 23, 2003 5:50 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: possible to have a primary key with a bitmap indx? > >

RE: possible to have a primary key with a bitmap indx?

2003-09-23 Thread Khedr, Waleed
Restrictions on Unique Indexes You cannot specify both UNIQUE and BITMAP -Original Message- Sent: Tuesday, September 23, 2003 5:35 PM To: Multiple recipients of list ORACLE-L It's not possible: SQL> create bitmap index emp_empno_b on emp(empno); Index created. SQL> alter table emp a

RE: possible to have a primary key with a bitmap indx?

2003-09-23 Thread Mladen Gogala
It's not possible: SQL> create bitmap index emp_empno_b on emp(empno); Index created. SQL> alter table emp add constraint emp_pk primary key(empno) using index emp_empno_b novalidate; alter table emp add constraint emp_pk primary key(empno) using index emp_empno_b novalidate * ERROR at line 1:

RE: possible to have a primary key with a bitmap indx?

2003-09-23 Thread Stephane Paquette
A bitmap index is for a low cardinality column, so I doubt it would be a good idea to use it to enforce a primary key. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED]