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.1 to 6.0.2 >

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

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

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;