Installation Guide for Oracle Self-Service E-Billing > Migrating to Oracle Self-Service E-Billing Version 6.2 > Process of Migrating Oracle Self-Service E-Billing Version 6.0 to Version 6.0.1 >

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

After successfully migrating the OLTP and OLAP databases, you must compile the schema.

This task is a step in Process of Migrating Oracle Self-Service E-Billing Version 6.0 to Version 6.0.1.

To compile the schema

1. On UNIX, log in as the ORACLE user for migration activity.
2. Go to the following directory:
   • UNIX. /opt/Oracle/eBilling/db/ebilling/oracle
   • Windows. \Oracle\eBilling\db\ebilling\oracle
3. Log on to the OLTP schema, using SQL*Plus, not as SYSDBA.
4. Run the following commands:

   SQL>@ compile_schema.sql

   SQL>exit;

5. Log on to the OLAP schema, using SQL*Plus, not as SYSDBA.
6. Run the following commands:

   SQL>@ compile_schema.sql

   SQL>exit;