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

Last updated on AUGUST 31, 2021

Applies to:

Symptoms

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:

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

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.

Changes

Cause

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