Upgrading an Existing OTM DB to 5.5.3 - Non-Partioned Option Used With Initial Install
(Doc ID 470877.1)
Last updated on MAY 06, 2022
Applies to:Oracle Transportation Management - Version 5.5.02 and later
Information in this document applies to any platform.
-- Problem Statement:
Non-partitioning option selected when OTM 5.5.2 database was originally installed. Oracle partitioning is installed/enabled in the database. Some of the new OTM 5.5.3 database installations encountered error ORA-00959 when running dbpatch_55 script when non-partitioning option was selected. The solution in that case was to re-install with partitioning.
The dbpatch_55.sql was run to upgrade the non-partitioned OTM db to 5.5.3 and received the same
error as before which is "VISIBILITY_PIECE ORA-00959: tablespace 'PART_1' does not exist". The
data in the current 5.5.2 database must be preserved when upgrading to 5.5.3.
-- Steps To Reproduce:
Run dbpatch_55 against OTM database to upgrade from 5.5.2 (installed with non-partitioning option)
-- Business Impact:
Need verification that the proposed solution will preserve the integrity of the existing data.
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