Clearing and Refreshing the Data

Previous TopicNext TopicContents

To clear and refresh all the data in the ODS database:

Note: This procedure assumes that you chose the default username (ODSUSER) 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 odsuser cascade;

  3. Run the following to drop the public synonyms for P6 EPPM data:

    begin

    for syndrop in (select synonym_name from all_synonyms where synonym_name like 'P6%')

    loop

    execute immediate 'drop public synonym '||syndrop.synonym_name;

    end LOOP;

    end;

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

Related Topics

Post Installation Administrative Tasks

Securing the odsetl.properties File

Creating a Filtered ODS

Scheduling the ODS Database Update

Manually Launching the ODS Database Update Process



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

Last Published Friday, January 31, 2014