Rebuilding the Schema

  

P6 Analytics has a new function to use when the star schema database needs to be recreated and history needs to be preserved. The "-r" function backs up the current data, rebuilds the schema, and repopulates the tables.  This new function allows the database to be restored to the default state and keep the current data intact.

  

  

  

To access this feature:

  

This function is executed when running the staretl.bat with the switch "-r".

  1. Launch the Command Prompt.
  2. Change the directory to the location of where P6 Reporting is installed.
  3. For Unix/Linux type: staretl.sh -r
  4. For Windows type: startetl.bat "-r".  Note: You must type "-r" with quotation marks in order for the command to run.

 

Legal Notices 
Copyright © 2008, 2013, Oracle and/or its affiliates. All rights reserved.