ERROR: "ORA-00439: feature not enabled: In-Memory Column Store" Or "ORA-00922: missing or invalid option" in DBSetup or Datapump Utilities (Doc ID 2629388.1)

Last updated on FEBRUARY 17, 2024

Applies to:

Symptoms

When attempting to upgrade P6 EPPM to release 19.12.x using the dbsetup utility, or when using datapump (expdp/impdp) to migrate a P6 database schema from an Oracle Enterprise Edition to an Oracle Standard Edition Database platform, one of the following errors occur.

ORA-00439: feature not enabled: In-Memory Column Store
ORA-06512: at line 7
SQL Query:
DECLARE
tbl_exists INTEGER;
BEGIN
SELECT COUNT(*) INTO tbl_exists FROM user_tables WHERE table_name =
UPPER('SAFETYDATE');
IF tbl_exists = 0
THEN
EXECUTE IMMEDIATE 'CREATE TABLE SAFETYDATE(
setting_name varchar2(30 CHAR) NOT NULL,
setting_value DATE NULL
,CONSTRAINT pk_setting_name PRIMARY KEY (setting_name) )
TABLESPACE PMDB_DAT1
STORAGE (INITIAL 1M NEXT 1M MAXEXTENTS UNLIMITED PCTINCREASE 0)
INMEMORY
';
END IF;
END;

--------

(ORA-00922: missing or invalid option
ORA-06512: at line 7
)
SQL Query:
DECLARE
  tbl_exists INTEGER;
 BEGIN
  SELECT COUNT(*) INTO tbl_exists FROM user_tables WHERE table_name =
UPPER('SAFETYDATE');
  IF tbl_exists = 0
  THEN
  EXECUTE IMMEDIATE 'CREATE TABLE SAFETYDATE(
  setting_name varchar2(30 CHAR) NOT NULL,
  setting_value DATE NULL
 ,CONSTRAINT pk_setting_name PRIMARY KEY (setting_name) )
 TABLESPACE PMDB_DAT1
  STORAGE (INITIAL 1M NEXT 1M MAXEXTENTS UNLIMITED PCTINCREASE 0)
 INMEMORY
 ';
  END IF;
 END;

The issue can be reproduced at will with the following steps:

1. Run dbsetup.bat to upgrade the P6 schema to P6 EPPM 19.12.x.
2. Provide the database connection details.
3. Step through the process.
4. Error occurs during the Perform core upgrade step.

--------

1. Use the Oracle Database expdp utility to export a P6 schema from a database hosted in an Oracle Enterprise Edition.
2. Use the impdp utility to import the P6 schema to a database hosted on Oracle Standard Edition.
3. Import fails; view the error in the log file.

Cause