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

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

To compile the schema for Oracle Self-Service E-Billing version 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.
  2. Go to the following directory:
    • UNIX. EDX_HOME/db/ebilling/oracle
    • Windows. EDX_HOME\db/ebilling\oracle
  3. Log on to the OLTP schema, using SQL*Plus, not as SYSDBA, and run the following commands:

    SQL>@ compile_schema.sql

    SQL>exit;

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

    SQL>@ compile_schema.sql

    SQL>exit;

Installation Guide for Oracle Self-Service E-Billing Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.