My Oracle Support Banner

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

Last updated on NOVEMBER 18, 2019

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

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


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