The scripts in this task are located in:
\database\scripts\install\PM_
<release_level>
To create users and tables:
Running the orpm_create_users.sql script automatically creates 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 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: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
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.
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.
Creating the P6 EPPM Database Structure for Oracle
Copying the Script Files to a Local Drive
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, September 22, 2016