Creating the Primavera Data Warehouse Tablespaces

If the tablespaces do not already exist, complete the following steps to create the Primavera Data Warehouse tablespaces:

Sign in to the Primavera Data Warehouse instance with a user that has Create Tablespace privileges (for example, SYS).
Note: If you are using an Oracle 12c pluggable database, use the Service Name to connect.
Create the necessary tablespace with the following statements:
CREATE SMALLFILE TABLESPACE STAR_DAT1 DATAFILE '<path>\<star_dat1>.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M SEGMENT SPACE MANAGEMENT AUTO;

where <star_dat1> is the name of the star tablespace and <path> is the path to the folder where the database instance data files reside (by default, \oracle\oradata\database name\).
Create the necessary history tablespace with the following statements:
CREATE SMALLFILE TABLESPACE STAR_HST1 DATAFILE '<path>\<star_hst1>.dbf' SIZE 100M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M SEGMENT SPACE MANAGEMENT AUTO;

where <star_hst1> is the name of the star history tablespace and <path> is the path to the folder where the database instance data files reside (by default, \oracle\oradata\database name\).
Ensure case sensitivity for the Primavera Analytics sample database instance is set to false for database logons with the following statement:
alter system set sec_case_sensitive_logon=false;
If you are using Oracle Data Integrator (ODI), create the ODI Target User and tablespaces with following statements:
CREATE TABLESPACE ODI_TGT_DAT1 DATAFILE '<path>/ODI_TGT_DAT1.dbf' SIZE 10M AUTOEXTEND ON;

CREATE TEMPORARY TABLESPACE ODI_TGT_TEMP TEMPFILE '<path>/ODI_STGT_TEMP_DAT1.dbf' SIZE 10M AUTOEXTEND ON;

CREATE USER ODI_TGT_USER IDENTIFIED BY oracle

DEFAULT TABLESPACE ODI_TGT_DAT1

TEMPORARY TABLESPACE ODI_TGT_TEMP

QUOTA UNLIMITED ON ODI_TGT_DAT1;

GRANT CONNECT, RESOURCE, SELECT ANY TABLE TO ODI_TGT_USER;

where <path> is the path to the folder where the database instance data files reside.
Log out of the database instance.

At this point, the Oracle instance should be ready for installation of the Primavera Data Warehouse software.

Related Topics