Creating Users and Tables for Oracle

Previous TopicNext TopicContents

The scripts in this task are located in:

\database\scripts\install\PM_<release_level>

To create users and tables:

  1. Execute the following steps:
    1. From the command line, execute: sqlplus <system>/password@<db_tns_names_entry>
    2. Execute the orpm_create_users.sql script.

      Running the orpm_create_users.sql script automatically creates database user names: admuser, privuser, pubuser, pxrptser, and bgjobuser. If you want to create non-default usernames, you must first open the script in a text editor and then replace the default references before you run the script.

      Running the orpm_create_users.sql script references the following default tablespace names: PMDB_DAT1, PMDB_NDX1, PMDB_LOB1, and PMDB_PX_DAT1. If you created the tablespaces using non-default names, you must first open the script in a text editor and replace the default references before you run the script.

      Note: Do not use special characters in the database name, privileged user, public user, or PX reporting user name, for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `

    3. Execute the orpm_grant_privileges.sql script.

      Running the orpm_grant_privileges.sql script references the following database user names: admuser, privuser, pubuser, pxrptuser, and bgjobuser. If you want to create non-default usernames, you must first open the script in a text editor and then replace the default references prior to running the script.

  2. Execute the following steps:
    1. From the command line, execute: sqlplus <admuser>/password@<db_tns_names_entry>
    2. Execute the orpm_tables.sql script.

      Running the orpm_tables.sql script references the following default user names: privuser, pubuser, and pxrptuser. If you created non-default user names, you must first open the script in a text editor and replace the default references before you run the script.

      Running the orpm_tables.sql script references the following default tablespace names: PMDB_DAT1, PMDB_LOB1, and PMDB_PX_DAT1. If you created the tablespaces using non-default names, you must first open the script in a text editor and replace the default references before you run the script.

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 the Database Tablespaces 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