Error: "Error in Run SQL Script orpm_tables.sql: DatabaseToolException (ORA-00902: invalid datatype)" Creating Or Upgrading A P6 EPPM Database
(Doc ID 1389459.1)
Last updated on DECEMBER 05, 2019
Primavera P6 Enterprise Project Portfolio Management - Version 188.8.131.52 and later Primavera P6 Professional Project Management - Version 184.108.40.206 to 220.127.116.11 [Release 15.2] Information in this document applies to any platform.
***Checked for relevance on 18-Aug-2014***
When creating or upgrading a P6 EPPM database to r8.2 or later using dbsetup.bat (or .sh if running on non-windows), the following error occurs:
ERROR -------------- Error in Run SQL Script orpm_tables.sql: DatabaseToolException (ORA-00902: invalid datatype)
Note: The same issue will occur when creating the database manually and executing the orpm_tables.sql script. When creating the LOCATION table, the following error occurs:
geo_location SDO_GEOMETRY NULL, * ERROR at line ###: ORA-00902: invalid datatype
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!