To create tablespaces and schema for the Enterprise Reporter database instance

1. Log on to the host where the Oracle database resides.

2. 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

3. To run the tablespace creation script, type the following command:

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

   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 2.
   directory_location	is the fully qualified path to the directory that should contain the database files. This directory must already exist and it must have write permission for the Oracle user who runs the Oracle database.

4. To run the schema creation SQL, type the following command from a writeable location:

   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 2.