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

Compiling the Schema for the Oracle Self-Service E-Billing 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 6.0 to 6.0.1.

To compile the schema

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

   SQL>@ compile_schema.sql

   SQL>exit;

4. Log on to the OLAP schema using SQL*Plus (not as SYSDBA).
5. Run the following commands:

   SQL>@ compile_schema.sql

   SQL>exit;