Upgrade Scripts for 5.5 on Oracle

ALBPM Enterprise 6.0.3+ (on the first Hotfix) includes SQL scripts for upgrading the structure of ALBPM 5.5 databases on Oracle. These scripts are located under the following directory: <ALBPM_DIR>/conf/migration/oracle/.

The scripts are grouped in sub-directories for each ALBPM database: archiving, bam, dataMart, engine, directory.

Here is the list of files included for upgrading ALBPM 5.5 Oracle databases to ALBPM 6.0:

  oracle/
  |-- archiving/
  |   |-- 0ReadmeFirst.txt
  |   |-- 1AlterTables.sql
  |   |-- 2RebuildIndexes.sql
  |   |-- ArchivingDatabaseDifferencesReport5511to602.html
  |   `-- OracleArchiving602DatabaseSchema.sql
  |-- bam/
  |   |-- 0ReadmeFirst.txt
  |   |-- 1DisableConstraints.sql
  |   |-- 2AlterTables.sql
  |   |-- 3RebuildIndexes.sql
  |   |-- 4EnableConstraints.sql
  |   |-- 5UpdateExternalVariablesIfAny.sql
  |   |-- BamDatabaseDifferencesReport5511to602.html
  |   `-- OracleBam602DatabaseSchema.sql
  |-- dataMart/
  |   |-- 0ReadmeFirst.txt
  |   |-- 1DisableConstraints.sql
  |   |-- 2AlterTables.sql
  |   |-- 3RebuildIndexes.sql
  |   |-- 4EnableConstraints.sql
  |   |-- 5UpdateExternalVariablesIfAny.sql
  |   |-- DataMart602DatabaseSchema.sql
  |   `-- DataMartatDabaseDifferencesReport5511to602.html
  |-- directory/
  |   |-- 0ReadmeFirst.txt
  |   |-- 1DisableConstraints.sql
  |   |-- 2AlterTables.sql
  |   |-- 3RebuildIndexes.sql
  |   |-- 4EnableConstraints.sql
  |   |-- 5UpdateFDIVersionInfo.sql
  |   |-- FDIDatabaseDifferencesReport5511to602.html
  |   `-- OracleFDI602DatabaseSchema.sql
  `-- engine/
      |-- 0ReadmeFirst.txt
      |-- 1AlterTables.sql
      |-- 2RebuildIndexes.sql
      |-- 3UpdateExternalVariablesIfAny.sql
      |-- ENGINEDatabaseDifferencesReport5511to602.html
      `-- OracleEngine602DatabaseSchema.sql

The 0ReadmeFirst.txt files include additional instructions about the scripts and how to run them.

The .sql files prefixed with a number are the SQL scripts you must execute for converting the 5.5 schemas to 6.0.2, as described in Upgrade ALBPM 5.5 Oracle DBs.

Important: You must run more than one SQL script on each database, in the right order. The file name of each SQL script is prefixed with a number indicating the order in which they must be executed.

For each database, a complete SQL script describing the 6.0 schema structure is also included for your reference.

The .html files are reports of the schema differences between version 5.5 and 6.0, included for your reference.