How to fix this error and warning.

2003-11-07
2003-11-08
  • Dear Sir,

    Any one can help me to fix this warning and error when I try to RUN_ImportReference.

    Thanks in advances.

    IMP-00017: following statement failed with ORACLE error 439:
    "CREATE BITMAP INDEX "C_ALLOCATION_POSTED" ON "C_ALLOCATION" ("POSTED" )  PC"
    "TFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST"
    " GROUPS 1) TABLESPACE "INDX" LOGGING"
    IMP-00003: ORACLE error 439 encountered
    ORA-00439: feature not enabled: Bit-mapped indexes
    IMP-00017: following statement failed with ORACLE error 439:
    "CREATE BITMAP INDEX "C_ORDER_POSTED" ON "C_ORDER" ("POSTED" )  PCTFREE 10 I"
    "NITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1)"
    " TABLESPACE "INDX" LOGGING"
    IMP-00003: ORACLE error 439 encountered
    ORA-00439: feature not enabled: Bit-mapped indexes
    IMP-00017: following statement failed with ORACLE error 439:
    "CREATE BITMAP INDEX "C_PAYMENT_POSTED" ON "C_PAYMENT" ("POSTED" )  PCTFREE "
    "10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUP"
    "S 1) TABLESPACE "INDX" LOGGING"
    IMP-00003: ORACLE error 439 encountered
    ORA-00439: feature not enabled: Bit-mapped indexes
    IMP-00017: following statement failed with ORACLE error 439:
    "CREATE BITMAP INDEX "GL_JOURNAL_POSTED" ON "GL_JOURNAL" ("POSTED" )  PCTFRE"
    "E 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GRO"
    "UPS 1) TABLESPACE "INDX" LOGGING"
    IMP-00003: ORACLE error 439 encountered
    ORA-00439: feature not enabled: Bit-mapped indexes
    IMP-00017: following statement failed with ORACLE error 439:
    "CREATE BITMAP INDEX "M_INOUT_POSTED" ON "M_INOUT" ("POSTED" )  PCTFREE 10 I"
    "NITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 FREELISTS 1 FREELIST GROUPS 1)"
    " TABLESPACE "INDX" LOGGING"
    IMP-00003: ORACLE error 439 encountered
    ORA-00439: feature not enabled: Bit-mapped indexes
    About to enable constraints...
    Import terminated successfully with warnings.

     
    • Marco LOMBARDO
      Marco LOMBARDO
      2003-11-08

      Bitmap indexes are not included in the Standard edition, I think starting from release 9.0.
      They are included inthe Enterprise edition.

      regards,

      Mar