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 has been reported as DE78809 and reviewed by SE.
This will be addressed in a future release.
As of now, the following workaround can be used to manually exclude the index at import time:
> impdp system/<system_password> DIRECTORY=import_directory transform=oid:n DUMPFILE=oracle_base.db SCHEMAS=niku LOGFILE=import.log EXCLUDE=INDEX:"=CMN_SEC_GROUPS_N6"