ORA - 00439

Printable View

12-13-2001, 05:12 AM
ShrutiM

Hi!!

I installed oracle 8.1.6 Standrad Edition on Redhat Linux 6.2.
Whan I tried to import a dump made from Oracle 8i Enterprise Edition to it I gave me this error "BITMAPPED INDEXES FEATURE NOT ENABLED".

PLease tell how to enable this feature, it is important.

Regards
Shruti
12-13-2001, 05:18 AM
aarroyob

Hi,

Maybe you have a value less than 8.1.6 for the compatible parameter on your init.ora.

Hope that helps

Angel
12-13-2001, 05:25 AM
julian

Quote:

Originally posted by aarroyob
Hi,

Maybe you have a value less than 8.1.6 for the compatible parameter on your init.ora.

Hope that helps

Angel

No, that's not true.

In order to use bitmap indexes you MUST run EE. SE is not enough.
12-13-2001, 05:31 AM
xiaomao

Hi, Did you install oracle8i along with partition option. If not, you may encounter this error. Using this command to check whether the partition was installed or not.

SELECT * FROM v$option where parameter = 'Partitioning';

result should be 'true'.

Also you can lunch sqlplus or svrmgrl, you will see this message in the banner.

With the Partitioning option..
12-13-2001, 06:15 AM
ShrutiM

Thanks Julian,

I also searched the technet to get the information about this feature not being in SE.

Regards
Shruti
12-13-2001, 07:21 AM
julian

Quote:

Originally posted by xiaomao
Hi, Did you install oracle8i along with partition option. If not, you may encounter this error. Using this command to check whether the partition was installed or not.

SELECT * FROM v$option where parameter = 'Partitioning';

result should be 'true'.

Also you can lunch sqlplus or svrmgrl, you will see this message in the banner.

With the Partitioning option..

The problem he has, has nothing to do with the Partitioning option. He has installed SE and thus cannot use bitmap indexes.