Use the following procedure to upgrade to the latest version if the previous version of P6 Reporting Database included Star.
Note: The upgrade file only works if you are upgrading from R3.0 and above. If you are upgrading from any other previous release, you need to follow the instructions for upgrading to P6 Reporting Database R3.0 (see the "Upgrading the Star Database" section) before proceeding with these instructions. For instructions, go to http://docs.oracle.com/cd/E27225_01/English/Install_and_Config/Admin_PDF_Library/p6_reporting_database_install_and_config_guide.pdf.
Note: Before proceeding, Oracle recommends you backup your existing Star schema fully.
Notes:
ALTER USER STARUSER QUOTA unlimited ON STAR_HST1;
where STARUSER is the user name and STAR_HST1 is a tablespace. If you changed the STARUSER name, change it in the command; it should match the user name for the database you are upgrading.
Once this finishes, your Star Schema will be P6 Reporting Database 3.2.
Related Topics |
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014