The Primavera Data Warehouse sample schema is meant for demonstration purposes only. Oracle recommends that you import the sample schema into a unique Oracle Database instance. Do not install sample schema in the same instance as the production Primavera Data Warehouse instance.
Notes:
- Running the STARETL/ODI process against the restored sample Primavera Data Warehouse schema will impact the content in the sample schema.
- Make sure that the PATH variable includes the path to your ORACLE_HOME/bin directory.
Do the following to create the Oracle tablespaces that are required for Primavera Data Warehouse. These steps assume that an Oracle instance has already been created. For information about creating an Oracle instance, see https://docs.oracle.com/cd/E11882_01/server.112/e25494/create.htm#ADMIN002.
Once the Oracle instance is created, complete the following steps to create the sample Primavera Data Warehouse Tablespaces:
- Sign in to the sample Primavera Data Warehouse instance as a user with DBA privileges. For example, SYSTEM.
- If these tablespaces do not already exist, create the necessary tablespaces with the following statements:
create tablespace <STAR_DAT1>
datafile '<path>/STAR_DAT1.dbf'
Size 32m
Autoextend on
Extent management local;
where
<STAR_DAT1> is the name of the star tablespace.
<path> is the path to the folder where the database resides.
- If these tablespaces do not already exist, create the necessary tablespaces with the following statements:
create tablespace <STAR_HST1>
datafile '<path>/STAR_HST1.dbf'
Size 32m
Autoextend on
Extent management local;
where
<STAR_HST1> is the name of the star history tablespace.
<path> is the path to the folder where the data files reside.
- Since the Oracle Data Pump export was created using the database username of STARUSER, the import and the sample Primavera Data Warehouse schema username must also be STARUSER.
Create the database user STARUSER with the following statements:
prompt Creating users STARUSER
--METADATA TYPE:USER CHANGE:CREATE NAME:STARUSER
create user STARUSER
identified by <password>
temporary tablespace <temp_table>
default tablespace <STAR_DAT1>
;
--METADATA TYPE:GRANT CHANGE:CREATE PRIVILEGE:DBA GRANTEE:STARUSER
grant dba to STARUSER;
--METADATA TYPE:GRANT CHANGE:CREATE PRIVILEGE:JOB GRANTEE:STARUSER
grant create any job to STARUSER;
where
<password> is that STARUSER password.
<temp_table> is the name of the tablespace for temporary data.
<STAR_DAT1> is the name of the Star tablespace.
- Create a directory object within the instance for the dump file with the following SQL statement:
create or replace directory dmpdir as '<path_to_file>';
where <path_to_file> is the location of the data extracted from the sample_expdp.zip file.
- 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;
- Sign out of the database instance.
Continue to Importing the Primavera Data Warehouse Sample Schema.