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 NOVEMBER 29, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 8.2.0.0 and later
Primavera P6 Professional Project Management - Version 15.2.0.0 to 15.2.0.0 [Release 15.2]
Information in this document applies to any platform.
***Checked for relevance on 18-Aug-2014***

Symptoms

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

Cause

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