How to execute the model compare Reports For MSS 6.2.1 (Doc ID 2161302.1)

Last updated on AUGUST 03, 2016

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.

Goal

How to execute the model compare Reports

Overview of Model Compare “Reports” in MSS:
There are two main scripts which help them to determine if their is any difference in MSS database instance is “correct” vs. the MSS data model

• Model Current Report (mdl_upd_cur.sql; mdl_cur.sql)
       This report (script) identifies missing tables or columns, extra tables or columns, and differences with column data types.

• Model Compare Report (mdl_upd_cmp.sql; mdl_cmp.sql)
       This script helps maintain the database structure for primary and foreign keys, indexes, and sequences.

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms