Creating the Database Tablespaces for Oracle

You must create specific tablespaces to use an Oracle database with your P6 EPPM installation.

To create database tablespaces:

  1. Complete the following steps:
    1. From the command line, run: sqlplus <system>/password@<db_tns_names_entry>:
    2. Go to \database\scripts\install\PM_<release_level> and run the orpm_init_db.sql script.

      This script creates the following tablespaces:

      • PMDB_DAT1
      • PMDB_NDX1
      • PMDB_LOB1
      • PMDB_PX_DAT1

      If you want to change the names of the tablespaces that are listed above, you must modify the orpm_init_db.sql script before you run it.

      Notes:

      • Do not use special characters in the database name, privileged user, public user, or PX reporting user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
      • Instead of running the orpm_init_db.sql script, you can manually create a database with system, temporary, and undo tablespaces. Oracle recommends that you create a database with a 500 MB temporary tablespace and a 500 MB undo tablespace. Make sure that the Oracle client can connect to the database. Refer to your Oracle database documentation if you are unfamiliar with this process.

Related Topics

Creating the P6 EPPM Database Structure for Oracle

Copying the Script Files to a Local Drive

Grant Privileges to the SYSTEM User

Creating Users and Tables for Oracle

Installing Sample Data and Creating Your P6 EPPM Admin Superuser Password for Oracle

Creating Remaining Database Objects for Oracle


Last Published Tuesday, November 28, 2023