Upgrade from 4.2 b

Table of Contents Note System Cleanup database schema after upgrade Drop ALF_*ATTRIBUTE* tables (if exist) Recreate IDX_AVM_VR_UQ and drop unnamed constraint Fix type of column ID_ in table ACT_HI_DETAIL Add missing index IDX_ALF_NODE_TXN_TYPE

Note

Our tests has been done without data. Please run a test migration with a copy of your real data. Some of the old schemes contains small errors, which we were not able to fix at the current time. If you want a clean scheme, you need to fix it manually.

System

Linux: Ubuntu Linux Server

Java: Oracle JDK 1.7

Alfresco version: 4.2_b

Alfresco Oracle version: 4.2_b

Oracle version: 10.2g

Cleanup database schema after upgrade

Drop ALF_*ATTRIBUTE* tables (if exist)

 drop sequence ALF_ATTRIBUTES_SEQ;
 drop table ALF_GLOBAL_ATTRIBUTES;
 drop table ALF_LIST_ATTRIBUTE_ENTRIES;
 drop table ALF_MAP_ATTRIBUTE_ENTRIES;
 drop table ALF_ATTRIBUTES;

Recreate IDX_AVM_VR_UQ and drop unnamed constraint

Find constraint:

 select index_name
 from user_ind_columns
 where table_name = 'AVM_VERSION_ROOTS'
 and column_name = 'VERSION_ID'
 and index_name like 'SYS%';

The result is the name of the constraint we want to drop:

 INDEX_NAME
 ------------------------------
 SYS_C0067296

Now drop the constraint and recreate IDX_AVM_VR_UQ:

 alter table avm_version_roots drop constraint idx_avm_vr_uq;
 alter table avm_version_roots drop constraint SYS_C0067296;
 alter table avm_version_roots
    add constraint idx_avm_vr_uq
    unique (avm_store_id, version_id);

Fix type of column ID_ in table ACT_HI_DETAIL

 alter table ACT_HI_DETAIL modify (ID_ NVARCHAR2(64));

Add missing index IDX_ALF_NODE_TXN_TYPE

 create index idx_alf_node_txn_type on alf_node (transaction_id, type_qname_id);