Create Bitmap index on primary key [message #435632] |
Thu, 17 December 2009 02:50  |
sunil.madnani
Messages: 36 Registered: March 2007 Location: BHILAI
|
Member |
|
|
Hello Gurus,
I want to create Bit map index on primary key column of a table.Is it possible? and i am getting an error ora-00439.
e.g.
create table empdtls( emp_id number primary key,
emp_name varchar2(200));
create bitmap index b_ind on empdtls(emp_id);
I want to know is the right way to create bitmap index or not.
Regards:
Sunil Madnani
|
|
|
Re: Create Bitmap index on primary key [message #435635 is a reply to message #435632] |
Thu, 17 December 2009 03:00   |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
You don't want to do that. A primary key is a VERY poor candidate for a Bitmap index. Think of a different way. (I would also suggest that you read and understand the documentation before attempting to implement a feature that you have little knowledge of).
In addition, a simple and very quick google would have given you:
Quote:ORA-00439: feature not enabled: string
Cause: The specified feature is not enabled.
Action: Do not attempt to use this feature.
I would say that this is pretty obvious.
[Updated on: Thu, 17 December 2009 03:02] Report message to a moderator
|
|
|
|
Re: Create Bitmap index on primary key [message #435913 is a reply to message #435632] |
Fri, 18 December 2009 21:14  |
 |
Kevin Meade
Messages: 2103 Registered: December 1999 Location: Connecticut USA
|
Senior Member |
|
|
Once again we have a an error message but not text. I have no desire to look the error up.
Why did you take the time to write a post to us, give us an error number, but then not take the time to give us the text of the message?
One of my peeves! Kevin
|
|
|