To drop users and the Enterprise Reporter schema and recreate the schema

1. Copy the contents of the following directory to a writeable temp directory:

   Solaris	installer_location/sol_sparc/command_central_enterprise_reporter/scripts/db
   Windows	installer_location\win\command_central_enterprise_reporter\scripts\db

   where installer_location is one of the following:

   • The directory in which you extracted the installation files

   • The location of your DVD-ROM drive

2. Type the following command to drop users and the Enterprise Reporter schema:

   Solaris	sqlplus sys/password@ccer as sysdba @path_to_files/saharaDropUsers.sql
   Windows	sqlplus sys/password@ccer as sysdba @path_to_files\saharaDropUsers.sql

   where:

   sys and password	are the database credentials.
   ccer	is the instance name.
   path_to_files	is the location where the Enterprise Reporter database schema scripts reside. These are the scripts that you copied in step 1.

3. Type the following command to recreate the schema:

   Solaris	sqlplus sys/password@ccer as sysdba @path_to_files/sahara.sql
   Windows	sqlplus sys/password@ccer as sysdba @path_to_files\sahara.sql

   where:

   sys and password	are the database credentials.
   ccer	is the instance name.
   path_to_files	is the location where the Enterprise Reporter database schema scripts reside. These are the scripts that you copied in step 1.