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 JANUARY 11, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version and later
Primavera P6 Professional Project Management - Version to [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 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


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