Creating the ODI Source User

To create the Oracle Data Integrator (ODI) Source User, complete the following steps:

Sign in to the P6 EPPM or Primavera Unifier instance with administration privileges. For example, SYSTEM.
Use the following statements to create the ODI Source User and tablespaces:
CREATE TABLESPACE ODI_SRC_DAT1 DATAFILE '<path>/ODI_SRC_DAT1.dbf' SIZE 10M AUTOEXTEND ON;

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

CREATE USER ODI_SRC_USER IDENTIFIED BY oracle

DEFAULT TABLESPACE ODI_SRC_DAT1

TEMPORARY TABLESPACE ODI_SRC_TEMP

QUOTA UNLIMITED ON ODI_SRC_DAT1;

GRANT CONNECT, RESOURCE, SELECT ANY TABLE TO ODI_SRC_USER;

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