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.