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

Last updated on SEPTEMBER 15, 2017

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_W25B_2E896085"."TMP_T780755079" ("C1" 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

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms