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

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

book

Article ID: 277007

calendar_today

Updated On:

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"