The tablespaces for the Primavera Portfolio Management schema are defined by the names of <USERNAME>_USER and <USERNAME>_TEMP. They are created on two data files: <USERNAME>_USER.ora and <USERNAME>_TEMP.ora
- Use the following commands to create the user tablespaces as shown below based on chosen 512MB size for user tablespace:
SQL> CREATE TABLESPACE <USERNAME>_USER DATAFILE ‘<DATA_PATH>\<USERNAME>_USER.ora’ SIZE 512M REUSE AUTOEXTEND ON;SQL> CREATE TEMPORARY TABLESPACE <USERNAME>_TEMP TEMPFILE ‘<DATA_PATH>\<USERNAME>_TEMP.ora’ SIZE 100M REUSE AUTOEXTEND ON MAXSIZE 5000M;Where:
<USERNAME>:Oracle schema name used for Primavera Portfolio Management installation.<DATA_PATH>: A path to the datafiles. For example, C:\oracle\product\11.2.0\oradata\ORCL or C:\app\oracle\oradata\cdb\pdb\<USER_NAME>_USER.ora.- Notes:
- For very large databases and enough storage space,
TEMPORARY TABLESPACE MAXSIZEcan be changed from the mentioned 5000M. - The datafiles location path can be changed during user creation.
- Create a user as follows:
SQL> CREATE USER <USERNAME> IDENTIFIED BY <PASSWORD> DEFAULT TABLESPACE <USERNAME>_USER TEMPORARY TABLESPACE <USERNAME>_TEMP QUOTA UNLIMITED ON <USERNAME>_USER PROFILE DEFAULT ACCOUNT UNLOCK;SQL> GRANT CONNECT, RESOURCE, CREATE VIEW, CREATE TABLE TO <USERNAME>;SQL> GRANT READ, WRITE ON DIRECTORY DATA_PUMP_DIR TO <USERNAME>;SQL> GRANT SELECT ON sys.V_$INSTANCE TO <USERNAME>;SQL> GRANT EXECUTE ON sys.DBMS_LOCK TO <USERNAME>;Where:
<USERNAME>:Oracle schema name used for Primavera Portfolio Management installation.<PASSWORD>:Oracle user password<DATA_PATH>: A path to the datafiles. For example, C:\oracle\product\11.2.0\oradata\ORCL or C:\app\oracle\oradata\cdb\pdb\<USER_NAME>_USER.ora. - Check for the new user as follows:
SQL> Select * from dba_users where username = ‘<USERNAME>’;