E1: UPGTC: Unable To Run *ALTER Table Conversions On Compressed Tables, Getting ORA-39726 Error (Doc ID 1987747.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On : Apps Release: E1 9.1, Tools Release: 9.1.4.6

When attempting to upgrade from 8.11sp1 to 9.1, the following error occurs while running table conversions

ERROR
-----------------------
OCI0000178 - Unable to execute - ALTER TABLE PRODDTA.F42199 ADD (SLALLOC NCHAR(1) DEFAULT ' ', SLFULPID NUMBER(15) DEFAULT 0, SLALLSTS NCHAR(30) DEFAULT ' ', SLOSCORE NUMBER DEFAULT 0, SLOSCOREO NCHAR(1) DEFAULT ' ', SLCMCO NCHAR(5) DEFAULT ' ', SLKITID NUMBER DEFAULT 0, SLKITAMTDOM NUMBER DEFAULT 0, SLKITAMTFOR NUMBER DEFAULT 0, SLKITDIRTY NCHAR(1) DEFAULT ' ', SLOCITT NCHAR(1) DEFAULT ' ', SLOCCARDNO NUMBER DEFAULT 0, SLPMPN NCHAR(30) DEFAULT ' ', SLPNS NUMBER DEFAULT 0 )

OCI0000179 - Error - ORA-39726: unsupported add/drop column operation on compressed tables
JDB9900401 - Failed to execute db request
JDB2490014 - Failed to execute alter table request
TCE9000 - ITCEAlterTableEx - failed on table F42199 with error#0.
Running Table Conversion F42199 *ALTERO


It won't run the new *ALTER method, and instead reverts to the old *ALTERO.

Changes

Table F42199 is compressed in 11g database, was exported from 11g and imported into 12c database

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