Export and import OSM model data and a range of orders from a large database schema. (Doc ID 1600731.1)

Last updated on MARCH 29, 2023

Applies to:

Oracle Communications Order and Service Management - Version 7.0.1 to 7.3.0.0.0 [Release 7.0.0 to 7.3.0]
Information in this document applies to any platform.

Purpose

This document outlines how to replicate an OSM schema with a subset of orders from a large schema. Exporting a large schema, with hundreds of thousands or millions of orders, can be impractical due to its size, the time it takes, and resources it requires to export. A more feasible solution is to selectively export specific orders or a range of orders.

Note: The steps and procedures outlined in this KM Note are for import/export purposes only. They are not to be used for other activities like system back up and restore. For example executing the om_exp_imp_util_pkg.purge_model procedure without a model export to restore the data will result in a non functioning OSM schema. For more information on how to back up and restore see the "Order and Service Management System Administrator's Guide".