My Oracle Support Banner

Error In Installing Table Instance After Updating Data Type (Doc ID 2307920.1)

Last updated on FEBRUARY 12, 2019

Applies to:

Oracle Life Sciences Data Hub - Version 2.4.6 and later
Information in this document applies to any platform.

Symptoms

ISSUE:
-------
Installing the WA fails if the column type is updated.

In the Work Area installation log the following errors are reported:

ORA-02220: invalid MINEXTENTS storage option value
SQL error = ORA-20003: The object is not in a valid state for the requested operation (ops_enabled)

In reorg.log, the following error is reported:

CREATE TABLE "CDR_W<ID>"."TMP_T<ID>" ("<COL_NAME>" VARCHAR2(20))
TABLESPACE "APPS_TS_TX_DATA" PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 255
STORAGE ( INITIAL 0K NEXT 0K MINEXTENTS 0 MAXEXTENTS 0 PCTINCREASE 0) LOGGING MONITORING
ERROR executing steps
ORA-02220: invalid MINEXTENTS storage option value

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.