Installation Guide for Oracle Self-Service E-Billing > Migrating to Oracle Self-Service E-Billing Version 6.0.4 > Roadmap for Migrating Oracle Self-Service E-Billing 6.0.2 to 6.0.3 >

Compiling the Schema for the Oracle Self-Service E-Billing 6.0.3 OLTP and OLAP Databases

After successfully migrating the OLTP and OLAP databases, you must compile the schema. Follow these steps for both UNIX and Windows.

This task is a step in Roadmap for Migrating Oracle Self-Service E-Billing 6.0.2 to 6.0.3.

To compile the schema for Oracle Self-Service E-Billing 6.0.3

1. After successfully migrating the OLAP and OLTP databases, you must compile the schema. On UNIX, log in as the ORACLE user for migration activity. Go to the EDX_HOME/db/ebilling/oracle directory (or the EDX_HOME\db\ebilling\oracle directory on Windows). In the path, EDX_HOME is the location where Oracle Self-Service E-Billing is installed.
2. Log on to the OLTP schema using SQL*Plus (not as SYSDBA), and run the following commands:

   SQL>@ compile_schema.sql

   SQL>exit;

3. Log on to the OLAP schema using SQL*Plus (not as SYSDBA), and run the following commands:

   SQL>@ compile_schema.sql

   SQL>exit;

4. After migrating to Oracle Self-Service E-Billing 6.0.3, you must create a new Command Center administrator user; the old user ID and password will not work.

   For details on creating a new administrator user in the Command Center, see Administration Guide for Oracle Self-Service E-Billing.