Creating the Database Tablespaces for Oracle

Previous TopicNext TopicContents

To create database tablespaces:

  1. Execute the following steps:
    1. From the command line, execute: sqlplus <system>/password@<db_tns_names_entry>:
    2. Go to \database\scripts\install\PM_<release_level> and execute 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 execute 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 for Oracle

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



Legal Notices
Copyright © 1999, 2016, Oracle and/or its affiliates. All rights reserved.

Last Published Thursday, February 04, 2016

PDF Library