Error "ORA-00959: tablespace 'PMDB_PX_DAT1' does not exist" When Attempting to Migrate a PPM (P6 Professional) Database Schema to an EPPM Schema
(Doc ID 2956153.1)
Last updated on JULY 02, 2023
Applies to:
Primavera P6 Professional Project Management - Version 22.12 to 22.12.5.0 [Release 22.12]Primavera P6 Enterprise Project Portfolio Management - Version 22.12 to 22.12.5.0 [Release 22.12]
Primavera P6 Enterprise Project Portfolio Management Cloud Service - Version 23.1 to 23.6 [Release 23.1 to 23.6]
Information in this document applies to any platform.
Symptoms
When running the migrate.bat utility to convert a PPM (P6 Professional) Database schema to an EPPM schema in a pluggable database instance, the following error occurs:
Error in Run SQL Script orppm_pm_migrate.sql : DatabaseToolException: ORA-00959: tablespace 'PMDB_PX_DAT1' does not exist)
The issue can be reproduced at will using the following steps:
- Create a new pluggable database instance to host the new EPPM schema.
- Connect to the instance as the system user and execute the following SQL command:
- When prompted to configure the Oracle Tablespaces for the target (EPPM) database, leave Use existing tablespaces unchecked so new ones will be created.
- When prompted to configure the PX Tablespace, leave Use existing tablespace unchecked and create a new one, then click Next.
- Observe the reported error.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |