Upgrading an Existing OTM DB to 5.5.3 - Non-Partioned Option Used With Initial Install
Last updated on SEPTEMBER 08, 2016
Applies to:Oracle Transportation Management - Version: 5.5.02
Information in this document applies to any platform.
***Checked for relevance on 08-Oct-2010***
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms