DDLIMP - ORA-39726 Error While Running Production Test Upgrade (Doc ID 1569923.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Sales - Version 8.2.2.3 SIA [23021] and later
Information in this document applies to any platform.

Symptoms

On : 8.2.2.3 SIA [23021] version, Upgrade

When attempting to run upgrade on production mode, it fails
the following error occurs in the ddlctl_tab.log

ERROR

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



STEPS

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


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