While importing the Clarity 16.2.0 'oracle_base.db' file on Oracle SE database, there is an error
creating a bit-mapped index, which is a feature that cannot be set to true on Oracle Standard Edition.
STEPS TO REPRODUCE:
1. Ensure the existence of the path to the OOTB 16.2.0 oracle_base.db file
2. Run the impdp command using the file.
3. The import runs until it errors with:
ORA-39083: Object type INDEX:"NIKU"."CMN_SEC_GROUPS_N6" failed to create with error:
ORA-00439: feature not enabled: Bit-mapped indexes
Failing sql is:
CREATE BITMAP INDEX "NIKU"."CMN_SEC_GROUPS_N6" ON "NIKU"."CMN_SEC_GROUPS" ("IS_HIDDEN", "IS_ACTIVE") PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "INDX_LARGE" PARALLEL 1
Expected: It should import fine on Oracle SE, as per the documentation (Hardware/Software Compatibility)
Actual: It fails .
Workaround:
Unable to set value from false to true, as it is Oracle Standard Edition, not Enterprise Edition
NOTE: Upgrading a working dump file import fine, but not the OOTB oracle_base.db file
This is reported as DE78809 and is resolved in the 16.2.1 release.