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, 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: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ `
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.
Related Topics |
Legal Notices
Copyright © 1999, 2016,
Oracle and/or its affiliates. All rights reserved.
Last Published Thursday, February 04, 2016