Installation Guide for Oracle Self-Service E-Billing > Migrating to Oracle Self-Service E-Billing Version 6.2 from Other Products > Process of Migrating the Oracle Communications Billing Analytics Version 5.1.1 Database to Oracle Self-Service E-Billing Version 6.0 >

Compiling the Schema After Migrating the OLTP and OLAP Oracle Communications Billing Analytics Databases

After successfully migrating the OLTP and OLAP Oracle Communications Billing Analytics databases, you must compile the schema.

This task is a step in Process of Migrating the Oracle Communications Billing Analytics Version 5.1.1 Database to Oracle Self-Service E-Billing Version 6.0.

To compile the schema after migrating the OLTP and OLAP Oracle Communications Billing Analytics databases

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

   SQL>@ compile_schema.sql

   SQL>exit;

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

   SQL>@ compile_schema.sql

   SQL>exit;