Oracle 19c Standard Edition (SE) Database Import Fails With 16.2.0 Stock Dump File

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

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

 

Cause

This has been reported as DE78809 and reviewed by SE.

Resolution

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"