My Oracle Support Banner

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 SEPTEMBER 25, 2023

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version and later
Primavera P6 Professional Project Management - Version and later
Information in this document applies to any platform.


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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 For low level instruction to manually install the Oracle Multimedia:
 For low level instruction to install the Oracle Multimedia using the Oracle Database Configuration Assistant (DBCA):
 To verify Oracle Multimedia was installed successfully:
 To restart the P6 EPPM Configuration Wizard after Oracle Multimedia is installed:

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.