Caution: Clearing the data from the Primavera Data Warehouse database removes all data, including all accumulated Project, Activity, and WBS history fact data. You cannot "undo" this action.
If needed, complete the following steps to drop all of the data (including all accumulated Project, Activity, and WBS history fact data) from the Primavera Data Warehouse schema:
- Log in to the Primavera Data Warehouse instance (with SQL Plus, SQL Developer, and so on) with a user account that has the Drop User privileges (for example, SYSTEM).
- Run the following command:
drop user <staruser> cascade;
where <staruser> is the username for your Primavera Data Warehouse (by default, STARUSER).
You can run the Setup process to populate the Primavera Data Warehouse database after executing this command. See the Primavera Data Warehouse Installation and Configuration Guide for details on running the Setup process.