DDLIMP - ORA-39726 Error While Running Production Test Upgrade
(Doc ID 1569923.1)
Last updated on MARCH 02, 2017
Applies to:Siebel Sales - Version 22.214.171.124 SIA  and later
Information in this document applies to any platform.
On : 126.96.36.199 SIA  version, Upgrade
When attempting to run upgrade on production mode, it fails
the following error occurs in the ddlctl_tab.log
alter table S_ACCNT_POSTN
add "ACCNT_TYPE_CD" varchar2(30 char)
add "CLIENT_FLG" char(1 char) default 'N'
add "CVRG_ROLE_CD" varchar2(30 char)
add "FACILITY_FLG" char(1 char) default 'N'
add "INVSTR_FLG" char(1 char) default 'N'
add "LAST_CALL_DT" date
add "NEXT_CALL_DT" date
add "NEXT_CALL_OBJECTIV" varchar2(1500 char)
add "PRIORITY_FLG" char(1 char) default 'N'
add "PROD_ID" varchar2(15 char)
add "PRTNR_FLG" char(1 char) default 'N'
add "SRV_PROVDR_FLG" char(1 char) default 'N'
2013-07-12 16:58:05 [tp][ODBC Oracle driver][Oracle]ORA-39726: unsupported add/drop column operation on compressed tables
The issue can be reproduced at customer side with the following steps:
1. regenerate schma.ddl and custrep.dat on dev
2. on prod test, run upgrade in production mode
3. it fails with the error above on ddlctl_tab.log
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|