AnsweredAssumed Answered

Oracle DB upgrade fails

Question asked by buksvdl on Jul 27, 2017
Latest reply on Aug 1, 2017 by cjose

alter table ACT_RE_PROCDEF add (ENGINE_VERSION_ NVARCHAR2(255));
update ACT_RE_PROCDEF set ENGINE_VERSION_ = 'activiti-5';

alter table ACT_RE_DEPLOYMENT add (ENGINE_VERSION_ NVARCHAR2(255));
update ACT_RE_DEPLOYMENT set ENGINE_VERSION_ = 'activiti-5';

alter table ACT_RU_EXECUTION add (ROOT_PROC_INST_ID_ NVARCHAR2(64));
create index ACT_IDX_EXEC_ROOT on ACT_RU_EXECUTION(ROOT_PROC_INST_ID_);

update ACT_GE_PROPERTY set VALUE_ = '6.0.0.0' where NAME_ = 'schema.version';

 

alter table ACT_RE_PROCDEF add (ENGINE_VERSION_ NVARCHAR2(255));

java.sql.SQLException: ORA-01430: column being added already exists in table

Outcomes