Restoring the P6 Analytics Sample Database

Previous TopicNext TopicContents

To restore the P6 Analytics sample database:

Note:

  1. Open the installation directory:
    1. Go to the sample\db folder.
    2. Extract the sample_expdp.zip file to a local drive.
  2. Create a new Oracle database instance for P6 Analytics Sample Data.
  3. Log into the newly created sample data instance as a SYSTEM or other DBA privileged user.
  4. 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, and path is the path to the folder where the database resides

  5. 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, and path is the path to the folder where the data files reside.

  6. Create the database users with the following statements:

    prompt Creating users username

    --METADATA TYPE:USER CHANGE:CREATE NAME:username

    create user username

    identified by password

    temporary tablespace temp_table

    default tablespace STAR_DAT1

    ;

    --METADATA TYPE:GRANT CHANGE:CREATE PRIVILEGE:DBA GRANTEE:username

    grant dba to username;

    --METADATA TYPE:GRANT CHANGE:CREATE PRIVILEGE:JOB GRANTEE:username

    grant create any job to username;

    where username is the name of the user for the Star database, password is that user's password, temp_table is the name of the tablespace for temporary data, and STAR_DAT1 is the name of the Star tablespace

  7. Create a directory object within the instance for the dump file with the following SQL statement:

    create directory dmpdir as 'path_to_file';

    where path_to_file is the location of the data extracted from the sample_expdp.zip file.

  8. Ensure case sensitivity for the P6 Analytics sample database instance is set to false for database logons with the following statement:

    alter system set sec_case_sensitive_logon=false;

  9. Log out of the database instance.
  10. Import the sample.expdp file using Oracle's datapump feature with the following command:

    impdp system/password@SAMPLE directory=dmpdir dumpfile=star32.expdp schemas=username logfile=sample.log

    where dmpdir is the directory that you created and username is the name of the user you created

  11. Re-run the create_context.sql script as staruser.

Related Topics

Setting Up the Sample Database, Repository Definition (.rpd), and Dashboards

Adding OBI Users for P6 Analytics Sample Data



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014