E1: UPGTC: Unable To Run *ALTER Table Conversions On Compressed Tables, Getting ORA-39726 Error
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.
On : Apps Release: E1 9.1, Tools Release: 126.96.36.199
When attempting to upgrade from 8.11sp1 to 9.1, the following error occurs while running table conversions
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.
Table F42199 is compressed in 11g database, was exported from 11g and imported into 12c database
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