PPM Migrate.bat does not use Non-Default TEMP Tablespace or Generates Error "ORA-00959: tablespace 'TEMP' does not exist" if TEMP does not Exist when Migrating a PPM Database to Oracle
(Doc ID 2225967.1)
Last updated on AUGUST 03, 2018
Applies to:Primavera P6 Professional Project Management - Version 184.108.40.206 and later
Information in this document applies to any platform.
When attempting to run the PPM version of the migrate.bat application to migrate a database to Oracle, and selecting a non-standard/named TEMP tablespace, the following error is generated:
[INFO] [TIMESTAMP] CREATE USER MCBU_ADMUSER
IDENTIFIED BY ---
TEMPORARY TABLESPACE TEMP
DEFAULT TABLESPACE MCBU_DAT1
[ERROR] [TIMESTAMP] ORA-00959: tablespace 'TEMP' does not exist
[ERROR] [TIMESTAMP] Database Error: error number=959
[ERROR] [TIMESTAMP] Error Message: ORA-00959: tablespace 'TEMP' does not exist
[WARN] [TIMESTAMP] [USER] Could not complete because the job "Run SQL Script orppm_create_users.sql" failed.
com.primavera.database.tools.DatabaseToolException: ORA-00959: tablespace 'TEMP' does not exist
STEPS TO REPRODUCE
1. Have an Oracle target database where the temporary tablespace is named anything other than the default of "TEMP"
2. Perform a migration to that Oracle database.
3. In the tablespace selection screen of migrate.bat, observe that the correct temporary tablespace is listed in the dropdown, and selected as expected.
4. When the migration begins to run, observe that the ADMUSER fails to create and that the SQL and output log file both reference that the user was attempted to be created with temporary tablespace of TEMP, not the correct non-default name.
Due to this issue, users cannot migrate using a non-standard/default TEMP tablespace.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!