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 >

Migrating the Oracle Communications Billing Analytics Version 5.1.1 OLAP Schema to Oracle Self-Service E-Billing Version 6.0 on Windows

This topic describes how to migrate the Oracle Communications Billing Analytics version 5.1.1 OLAP schema to Oracle Self-Service E-Billing version 6.0 on Windows.

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 migrate the Oracle Communications Billing Analytics version 5.1.1 OLAP schema to Oracle Self-Service E-Billing version 6.0 on Windows

1. Go to the EDX_HOME\db\oracle\olap\migration\511_6.0 directory, and make sure the migrate_olap_511_to_6.0.sql file exists. In the path, EDX_HOME is the Oracle Self-Service E-Billing installation directory.
2. Log in to the database as SYSDBA:

   export ORACLE_SID=myolap

   sqlplus "/as sysdba"

3. Grant the create materialized view privilege to the user you are migrating. In the command, User Name is the name of the user.

   SQL> grant create materialized view to User Name;

4. Replace the following parameters in the dblink.sql file with the values appropriate for your installation.

   Parameter	Value
   OLTP_USERNAME	The name of the OLTP schema user
   OLTP_PASSWORD	The password of the OLTP schema user
   OLTP_TNS_NAME	The TNS name of the OLTP instance

5. Log in to the OLAP database as the user you are migrating. Run the following script to create the database link name OLTP_LINK. Do not run the dblink.sql script as SYSDBA:

   dblink.sql

6. Run the migrate_olap_511_to_6.0.sql script from SQL*Plus:

   C:\set ORACLE_SID=olap

   C:\sqlplus oltp/oltp

   SQL> @ migrate_olap_511_to_6.0.sql

   SQL> exit;

7. Make sure there are no errors in the migrate_olap_511_to_6.0.log file.