My Oracle Support Banner

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

Last updated on AUGUST 31, 2021

Applies to:

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


When attempting to run Siebel Database upgrade on production mode, 
the following error occurs while processing ddlimp for tables and can be seen in the  ddlctl_tab.log file:


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


1. Regenerate schema.ddl and custrep.dat files in Dev environment (Siebel Database Upgrade Guide> Chapter 10 Upgrading the Siebel Database> Moving the Siebel Repository Files);
2. In prod test or production environment, run Siebel DB upgrade in production mode;
3. It fails with the error above in 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

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