Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set the option Bit-mapped indexes to true ?

674835Dec 11 2008 — edited Dec 11 2008
Hi,

I a not a an Oracle Administrator. Usually, I just use Oracle as developper. I have got a Oracle 10g database. I can not import data in my database because the Bit-mapped options is not set.

When I type

select banner from v$version

I get this result :

BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.1.0 - Production
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

I run the import and I get this error :

IMP-00017: following statement failed with ORACLE error 439:
"CREATE BITMAP INDEX "ID_ACC_DO" ON "ES_AUDIT_CONNEXION_ARCH" ("DATE_OUVERTU"
"RE" ) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 33554432 FREELIST"
"S 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "IND_XL" LOGGING"
IMP-00003: ORACLE error 439 encountered
ORA-00439: feature not enabled: Bit-mapped indexes

I typed the command :
SELECT * FROM V$OPTION WHERE PARAMETER LIKE 'Bit-mapped%';

I get the result :

PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
Bit-mapped indexes
FALSE

How to set this parameter to true ?

Best regards,

Xavier
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 8 2009
Added on Dec 11 2008
6 comments
9,446 views