Creating Non-partitioned Deployments

Previous TopicNext TopicContents

While Oracle recommends that you use a partitioned environment, P6 Reporting Database also supports non-partitioned environments with Oracle Database Standard Edition and Enterprise Edition. During the installation, you can choose to use a partition or non-partitioned environment in the Configuration Utility. The configuration utility will handle the steps below for creating a non-partitioned deployment. If you do not want to rerun configuration utility and chose a partitioned environment, please follow these steps to change to a non-partitioned deployment.

Note: You can rerun the Configuration Utility at any time.

If you deploy without partitioning, the following features are not supported:

If you use an Oracle Standard Edition database, partitioning is not available. To setup a non-partitioned P6 Reporting Database and P6 Analytics environment, do the following before running staretl:

  1. Rerun the configStar file from the <installation directory> and go back through the configuration and setup screens, making the same choices you made before.

    Note: Ensure the partitioning option is not selected on the ETL Settings page when deploying a non-partitioned database.

  2. Go to the <install_directory>\scripts folder.
    1. Move the following files to a different directory:
      • Create_star_indexes_part.sql
      • Create_star_tables_part.sql
    2. Rename the following scripts:
      1. Change Create_star_indexes.sql to Create_star_indexes_part.sql.
      2. Change Create_star_tables.sql to Create_star_tables_part.sql.

These changes cause the ETL process to use these scripts, which do not include partitioning, instead of the partitioned scripts.

Related Topics

Configuring an Oracle Standard Edition Database

Creating a New RPD for SE Security



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

Last Published Friday, January 31, 2014