Clearing the Data for Star

Previous TopicNext TopicContents

To clear all the data in the Star database including history data:

Note: This procedure assumes that you chose the default username (STARUSER) during the installation. If you chose a different name, use it instead of the default.

  1. Login to the P6 Reporting Database instance with a user account that has the Drop User system privilege (such as System).
  2. Run the following command:

    drop user staruser cascade;

    Caution: Deleting the Star database will also delete the Project, Activity, and WBS history fact data that was accumulated.

Dropping the user listed in step 2 of the preceding procedure will remove all data from the P6 Reporting Database instance. You can rerun the staretl file to populate the Star database with the P6 EPPM database information.

Related Topics

Post Installation Administrative Tasks

Securing the staretl.properties File

Refreshing the Data for Star

Creating a Filtered Star

Populate Data Sources with Filtered Project Data

Scheduling the Star Database Update

Manually Launching the Star Database Update Process

History Settings for P6 Reporting Database 3.2

Using Metadata

Backing up the Star Database Nightly



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

Last Published Friday, January 31, 2014