My Oracle Support Banner

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

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
Cause
Solution


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.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.