Once you have created and configured the sample Primavera Data Warehouse instance, complete the following steps to import the sample Primavera Data Warehouse schema:
- Run the following command to import sample.expdp using Oracle Data Pump:
impdp system/<password>@<SAMPLE> directory=<dmpdir> dumpfile=STAR152.expdp schemas=STARUSER logfile=sample.log
where
<password> is the password for the system account.
<SAMPLE> is the instance name for the sample Primavera Data Warehouse instance.
<dmpdir> is the directory that was created in the previous section, Creating a Sample Primavera Data Warehouse Instance.
- Sign in to the sample Primavera Data Warehouse instance (with SQL Plus, SQL Developer, and so on) with the STARUSER account that was created the previous section, Creating a Sample Primavera Data Warehouse Instance.
- Run the following command to create the context for the STARUSER:
CREATE OR REPLACE CONTEXT PRM_ANALYTICS_STARUSER USING secpac;
- Sign out of SQL Plus, SQL Developer, and so on.
At this point, the sample Primavera Data Warehouse instance is restored and ready to be accessed through Oracle Business Intelligence (OBI).