Upgrading an Existing OTM DB to 5.5.3 - Non-Partioned Option Used With Initial Install (Doc ID 470877.1)

Symptoms

-- 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)
to 5.5.3.

-- Business Impact:
Need verification that the proposed solution will preserve the integrity of the existing data.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.