My Oracle Support Banner

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

Last updated on FEBRUARY 27, 2024

Applies to:

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


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.



To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.