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.